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
My Visual Database → Script → 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
How do you query your date?
you can format date in SQL query, example
SELECT strftime('%d/%m/%Y', datefield) FROM ...
My Visual Database → Script → Date format in tablegrid
Powered by PunBB, supported by Informer Technologies, Inc.
Theme Hydrogen by Kushi