Joined: 19 May 2011
Online Status: Offline
Posts: 337
Posted: 06 Dec 2012 at 4:12am
There are many options to setup for date, if you right click on a date field you can go to formatting and see your options, and setup your own custom date formats.
tackling the 23rd, 22nd, etc, I am not sure how to do.
Joined: 07 Nov 2012
Online Status: Offline
Posts: 17
Posted: 06 Dec 2012 at 2:34pm
@DateToOrdinal
WhileReadingRecords;
NumberVar DayIn := Day (PrintDate); //or your {date.field}
"On this the"
& Totext (DayIn , 0 )
& (if DayIn in 4 to 20 then 'th' else
if remainder (DayIn , 10) = 1 then 'st' else
if remainder (DayIn , 10) = 2 then 'nd' else
if remainder (DayIn , 10) = 3 then 'rd' else 'th')
& " day of "
& Totext (PrintDate , "MMMM, yyyy") //again or your {date.field}
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
