I have a little problem with formatted search function.
I try to write a formatted search in the order document
which translate the docdate field to a string.
for exa. if the date is 20/03/2004- i want to translate it to: March 20, 2004 in another UDF field.
this is the query I am using:
SELECT convert(nvarchar(20), convert(datetime,$[ORDR.DOCDATE],101), 107) and it is not working, does anyone have an idea ???