My date column is coming in IST timezone and once I try to filter it for a specific date range:
Example 1 - 20th June data filtered.
Result: Data from 20th June 5:30am to 21st June 5:30am (This is UTC filtering)
Example 2 - 1st May 12:00am to 1st June 12:00am data filtered
Result: Data from 1st May 5:30am to 1st June 5:30am.
I am not able to find any resolution for this even after localization via metabase.
Any help would be immensely appreciated.