Joined: 13 Jun 2013, 23:47 Posts: 18
|
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
|
|