Hello everyone,
So I have this code to get data for today. My current way of comparing is to convert both the dateTime and Date into the same text format.
LookUp(MyTable, Text(CreatedOnDateTime, "[$-en-US]dd/mm/yyyy") = Text(Today(), "[$-en-US]dd/mm/yyyy"))
Is there any easier/simpler expression to compare dateTime with date? Thanks in advance.
Do you want your comparison to succeed only if the time part of the date/time expression is zero (00:00:00)? If so, then you can compare them directly:
LookUp(MyTable, CreatedOnDateTime = Today())
If you want to compare using only the date part of the DateTime expression, then you will need to use a conversion. Your solution is good, or you can also create a new Date value from the DateTime:
LookUp( MyTable, Date(Year(CreatedOnDateTime), Month(CreatedOnDateTime), Day(CreatedOnDateTime)) = Today())
User | Count |
---|---|
204 | |
93 | |
84 | |
47 | |
42 |
User | Count |
---|---|
251 | |
104 | |
104 | |
62 | |
57 |