I am attempting to retrieve data using a Q&A tool for a specific timestamp. While I can successfully fetch data for other timestamps, I encounter an issue when querying datasets within the time range of dd/mm/yyyy 12:00:00 PM to dd/mm/yyyy 12:59:59 PM. For this particular duration, the data cannot be fetched.
I suspect the tool is interpreting the timestamp as AM instead of PM. Is this a common problem, and is there a workaround for it?