Formatting a Date field

nicole

Hi there!...Help please...What's the syntax in formatting a Date field into this format: dd/mm/yy

Thanks in advance!

g_dreyer

Hi Nicole

textVariable := format(datefield,10,'<day,2>/<month,2>/<year>');
Please read up on the format command.

Regards,
Gus

PaLPiTaTioN

If you're going to work more with dates, it might also be handy to read the help files for the functions DATE2DWY, DATE2DMY, DWY2DATE and DMY2DATE. It gives the opportunity to retrieve only the day, week, month or year of a date and it makes it possible to compose dates.