Hi All,
In range filter, when we choose a month data, like for example july that will cover 1st to 31st of july. But the data of 31st july from 23.00 to 00.00 is getting shifted to next months 1st date i.e Aug. I tried using BuilddateTime function in ToDateTime but the issue persists.
Hello Aditya Chinchole,
Can you share the OML?
Best Regards,
Nuno R
Hi Aditya Chinchole,
Date Time is normally save until 23:59 (2021-07-31 23:59:59).
For example July 31 starts at 00:00 (2021-07-31 00:00:00) and ends at 23:59 (2021-07-31 23:59:59).
If you want to validate the full day of July 31, you can remove one second in the date of 1 of Aug for example. This way you will be able to validate the whole day of 31 of July. You get the date time of 2021-07-31 23:59:59
Something like the example I leave here, but with your variables.
Pedro C.