Adding the correct notation after a date

[Steve95]

Hi All

does any one know is their some kind of function in CRXi that adds a correct date notation ie. if its the first of the month it appears as 1st, 3rd or 24th and so forth.

Many Thanks

 

[lbass]

Try:

if remainder(day({table.date}),10) = 1 and
day({table.date}) <> 11 then
totext({table.date},"d")+"st" else

if remainder(day({table.date}),10) = 2 and
day({table.date}) <> 12 then
totext({table.date},"d")+"nd" else

if remainder(day({table.date}),10) = 3 and
day({table.date}) <> 13 then
totext({table.date},"d")+"rd" else

totext({table.date},"d")+"th"

-LB

 

[Steve95]

Thanks lbass for the above, but I forgot to mention that Iam working from a sql view and the field representing the date, returns the date as a singular number field eg. 28,27,1,3,4 etc etc

Any ideas, how i can add the notations?

Many Thanks

 

[lbass]

Change it to:

if remainder({table.no},10) = 1 and
{table.no} <> 11 then
totext({table.no},0,"")+"st" else

if remainder({table.no},10) = 2 and
{table.no} <> 12 then
totext({table.no},0,"")+"nd" else

if remainder({table.no},10) = 3 and
{table.no} <> 13 then
totext({table.no},0,"")+"rd" else

totext({table.no},0,"")+"th"

-LB