Formatting a Date field

nicole
nicole Member Posts: 25
edited 2004-12-01 in Navision Attain
Hi there!...Help please...What's the syntax in formatting a Date field into this format: dd/mm/yy

Thanks in advance!

:)

Comments

  • g_dreyer
    g_dreyer Member Posts: 123
    Hi Nicole

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

    Regards,
    Gus
  • PaLPiTaTioN
    PaLPiTaTioN Member Posts: 55
    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.

Categories