Skip to Content
0
Former Member
Mar 22, 2004 at 02:34 PM

SBO: Formatted Search

134 Views

Hi all

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 ???

Mark