convert date

[faiz_linda]

hi!

how can i convert the month in number e.g 4/1/2006 into 1 april 2006 using crystal report.the data in sql declared as datetime.

please advise...

[sraheem]

u don't need any formula , just format it.

[faiz_linda]

u don't need any formula , just format it.

thx :)..btw, can anybody help me on how to format it?? in the crytal rpt or in sql??

i have tried several times but failed. Somehow it will return a double type answer e.g. 4.00 instead of apr.

[sraheem]

right click on date field, select format text and select ur format