When trying to filter the data from datawindow using a date field as the
criteria, the date format is dd/mm/yy
the filter function has no effect . The pc's date format is checked and it
is having a mm/dd/yy setting. When the filter criteria is changed to
mm/dd/yy format ...similar to pc settings, the filter works.
PowerBuilder Datawindow Filter Function seems to depend on Control Panel,
Regional Setting's Date format when filtering.
Can i predefine the date format so that it will be following my data's
date format. Anybody out there knows wat's the way of doing this , please
advice..
Thank You!!
It may help to convert all elements in your filter expression to dates using
the Date function. This will ensure you are not comparing apples to
oranges. With this approach, I don't think the pc's settings come into
play.
Example:
ls_filter = "Date(last_access_dt) >= Date('" + String(ld_date, 'mmm dd,
yyyy') + "')"
Hope that helps.
Have you tried the following in your filter command:?
dw_1.SetFilter('string(dwdate, "dd/MM/yyyy") = "26/01/1998"')
where dwdate is the date field in you dw. This will not be affected by
whatever is defined in your Regional Settings.
--
Anita van Heerden
ani...@hollard.co.za