cfgrid date formatting

Hey guys.

I'm using html cfgrid and just realised that my date/time formatting mask shows a bit of a nonsense.

right, so the field in mysql database shows 2010-09-16 00:00:02.

when I output it to grid with following mask: "d/m/y H:NN:ss"

I get result:16/09/10 00:44:02

what is the right way to display minutes? cause it NN as referenced in livedocs does not work as it should.

thanks,

Simon

This topic has been closed for replies.

Inspiring

If you follow the manual and get the wrong results, raise a bug.

Known Participant

nevermind, figured it out myself testing every single letter and apparently it's 'i' that stands for minutes.

cheers,

Simon

Sign up