Date Format

sabzam

Hi Everybody,

The data is being printed as 15. December 2007; but I would either want to delete the . or instead place a th. Is this possible?

Alisha

format(workdate,0,'<Day> <Month Text> <Year4>');

That would give you 18 December 2007, you can add the "th" if you want after <Day>.

NaviDev

Suggestion for better result.

Create a function that will determine what will be postfix of the Day and return will return that value. Insert the function between the

format(workdate,0,'<Day>' + FUNCTION + '<Month Text> <Year4>');

.