• Registered: 2015-10-13
  • Posts: 38

Topic: Date format in tablegrid

Hi,

I'm loading a tablegrid using scrip. The table has a number of DATE fields and when loaded into the grid the format is YY/MM/DD. But I need it as DD/MM/YY with no time. Can you help please.

Thanks Terry

  • Registered: 2014-06-25
  • Posts: 863

Re: Date format in tablegrid

How do you query your date?

  • Registered: 2014-02-14
  • Posts: 10,294

Re: Date format in tablegrid

you can format date in SQL query, example


SELECT strftime('%d/%m/%Y', datefield) FROM ...
Dmitry.