Try - Formatdatetime(date, format)<BR><BR>Formatdatetime(010223, 2)<BR><BR>you can play with 0 through 4 I think.<BR><BR>!! Make sure you check your regional settings in your control panel too.<BR><BR>
Ender is correct. The question was how to format a date so that it appears as 010223, not how to turn that value into a date.<BR><BR>Your suggestion, outputs a date value of 27th december 2027. That is NOT what was being asked for.