EhLib.Com https://forum.ehlib.com/en/ |
|
Error when filter on date field in the database. https://forum.ehlib.com/en/viewtopic.php?f=5&t=345 |
Page 1 of 1 |
Author: | quatra42 [ 02 Jul 2013, 01:26 ] |
Post subject: | Error when filter on date field in the database. |
I have a date field in the database. if I set it on the global unit FormatSettings.DateSeparator: = '-'; FormatSettings.ShortDateFormat: = 'dd-mm-yyyy'; and to filter data based on the date the error occurred. but if I set it on the global unit FormatSettings.DateSeparator: = '/'; FormatSettings.ShortDateFormat: = 'mm/dd/yyyy'; and to filter data based on a date then there is no error. so how do i keep doing global settings on the unit FormatSettings.DateSeparator: = '-'; FormatSettings.ShortDateFormat: = 'dd-mm-yyyy'; and the error does not occur when the filter on the date field. TIA |
Page 1 of 1 | All times are UTC |
Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/ |