You might want to read this FAQ: https://docs.mendix.com/refguide/datetime-handling-faq/
Dates are always stored in the database in UTC. For an attribute you have the option to set localize to yes. The date is then still stored in UTC only when viewing the value Mendix will change it to the timezone of the user viewing the value.
Regards,
Ronald
Hi Yohanes,
I understand the issue here.
As today date is 2024-03-04, so as per condition it should return the second record.
It is returning the right record.
correct me if I'm wrong.
thanks for the reply Bhargav Ram Singh Bondili,
so this is the attributes of the entity, and yes i localize the attribute.
the fun fact is if i use the same condition for mendix page, i get the result that i want.
but, if its for the rest services, i get result like i said before
I tried with the same attributes and condition, it worked well.
Please refer screenshot for the microflow.
correct me if I'm wrong.
This is the microflow.
the list in on VersioningList and the condition that i struggle with is on VersioningActive.
and yeah, i too have same way on another microflow that used for mendix page and its works fine
but when is used it for REST Services, i got this problem.
so i think the problem is only when i using it for REST Services
I also tried with Rest API, Swagger page is retrieving the same result as desired.