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
4 answers
3

Hi Ikhwan,

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

Thank You

answered
0

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!

answered
0

Hi Ikhwan,

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

 

answered
0

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

answered