Question

Date format

0

Hi guys, Currently, i have a decision activity in my microflow. I want to find the same date for different two item. But, it cannot be done because Mendix read the time in the date format instead read the date only. For example, I want to find the same lot no and the same date. Anyone has any ideas?

asked 2021-10-05

Muhammad Ikhwan Afiq bin Azmir

4 answers

Gayathri Kadumuru · Accepted Answer · 2021-10-05

Hi Ikhwan,

You can use trim to days function. For eg: trimToDays($Date1) = trimToDays($Date2)

Thank You

Johan Munneke · Accepted Answer · 2021-10-05

Hi Ikhwan,

So if I understood correctly, you want to check whether the date is the same, ignoring the time? Perhaps you can do something like formatDate($A/Date, 'yyyyMMdd') = formatDate($Date, 'yyyyMMdd')?

Hope this helps!

Lukas Tost · Accepted Answer · 2021-10-05

Hi Ikhwan,

you are looking for the trim to date function. Have a look at https://docs.mendix.com/refguide/trim-to-date

Shekhar Tyagi · Accepted Answer · 2021-10-05

You can asalo use the function trimToDays on both the sides of the expression