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.