I was only adding a 'Z' at the end of the time format, as I thought is the case for ISO format. I removed the 'Z' and appended '+05:30' before indexing it and that has solved the problem for me. Thanks a lot!
Also adding this resource which helped me with the right format to use
1 Like