Convert date into Words

Naeem Khan

Hello friends,

I m facing a new problem in Crystal Report .. i have date like '20-07-2012' this date is coming from Data Base but its not store in String Format . so i want to convert into string format like twenty jul two thousand twelve. hope you understand what i want.. please give me formula.. how to do it .. its urgent friends...

Thanks in Advance

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sudhakar Chaudhary14y ago
it's working....try

towords(tonumber(day({?@DATE})),0)+" "+ MonthName(Month(DateAdd ("m", 0, {?@DATE})))+" "
+towords(tonumber(Year({?@DATE})),0)
Jignesh Trivedi14y ago
hi,

yes.

for get month name in Crystal report please refer..

http://crystaltricks.com/wordpress/?p=159
http://www.crystalreportsbook.com/Chapter06_XI.asp

hope this will help.
Vulpes14y ago
I can't really make it any shorter unless the date range is to be restricted in some way but, if Crystal Reports has built-in functions which can convert dates to words, then clearly Jignesh's approach is best.
Jignesh Trivedi14y ago
Hi Naeem Khan,
if your date 20-07-2012 then we can split by '-', so we can achive 20, 07, 2012...
crystal report has "toword" and "monthname" function with the help of them you may find your result
like
toword(dd) + " " + monthname(MM) + " " + toword(yyyy)
hope this will help you.
Naeem Khan14y ago
thanks for link,

its too long code .. do you have some small code which would be easy to apply..

Reply me ASAP...
Vulpes14y ago
Check out my article on this subject:

http://www.c-sharpcorner.com/UploadFile/b942f9/converting-dates-to-words-in-C-Sharp/