Hi,
I have a dbXpress application, and there is a Clientdataset which has a date field. I would like to filter the dataset by the date field. So it works for ex:
datefield >= '2005.05.24' and datefield <= '2005.05.25.'
IF the short date format (in the regional settings) is 'yyyy.MM.dd.'
BUT if the short date format is 'yyyy. MM. dd.' the above filter (even with: datefield >= '2005. 05. 24.') doesn't work.
I should override the locale settings but I don't know how...(it is not a solution to set the correct short date format on every machine where the application runs, because of the system privileges)
Plz help, how to make the date filter work on machines where the locale is different?
abbath8
I have a dbXpress application, and there is a Clientdataset which has a date field. I would like to filter the dataset by the date field. So it works for ex:
datefield >= '2005.05.24' and datefield <= '2005.05.25.'
IF the short date format (in the regional settings) is 'yyyy.MM.dd.'
BUT if the short date format is 'yyyy. MM. dd.' the above filter (even with: datefield >= '2005. 05. 24.') doesn't work.
I should override the locale settings but I don't know how...(it is not a solution to set the correct short date format on every machine where the application runs, because of the system privileges)
Plz help, how to make the date filter work on machines where the locale is different?
abbath8