date format

[Former Member]

Hi

can any one tell how to set date format as "20th sep 2010" in CR.

Thanks

[Former Member]

Hi Sweety,

to get the format you are after I think you will have to create a formula based on the date field that you are wanting to display.

Try this;

totext(datepart("d", {yourtable.yourtdate}),0) & "th "

& monthname(datepart("m", {yourtable.yourtdate}))

& " " & totext(year{yourtable.yourtdate}),0,"")

Regards,

Noel