Hi
Iam trying to filter a grid using start date(date and time) and end date(date and time)...
The server in MDT and Iam in CST...When Iam trying to filter the report on 06/06/2019 it is not showing up anything...where as when I search with 07th june 2019,it is showing up the before day report
Please let me know how can I handle this?
Discussion posts and replies are publicly visible
This is because a date converted to a datetime assumes the datetime is i12:00 AM GMT (see examples here: https://docs.appian.com/suite/help/19.2/fnc_conversion_todatetime.html) This then converts based on your timezones relation to UTC.
The best bet to try to filter purely on a date when the underlying field is a date time is to create a wrapper which has the datetime column converted to a date in the source (if the db this can be done with a view) and ensure that it is cast to a date before filtering.