25 as twenty fifth 1

[WTKnow]

Please, wizards how to make Ayug,25 to say 'On a twenty fifth day...' is there way? Thanks

 

[Madawc]

First, isolate the day. From a date, you can say DatePart("d", {your.date}), or maybe just Day({your.date}), depending on your version of Crystal.

Then use Crystal's automatic conversion:

 "On day " & ToWords(@YourDayNumber)

This would give On day twenty five. To get any closer would mean using commands like

Replace(@DateWord, "five", "fifth"

And so on.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[WTKnow]

Great but not clear...I need to have not just 25th but any day to convert.
So I need to write formula like

"On day " & ToWords(@YourDayNumber) but what (@YourDayNumber) should be like?
Should I strip Day off the Aug, 25 and make it (@YourDayNumber)formula and then use that in?

Please, let me know if I am missing much?
thanks a lot

 

[WTKnow]

I think I got it, THANKS!!!

 

[Madawc]

Glad to have helped. The second command should have been Replace(@DateWord, "five", "fifth"), of course.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10