Forum Discussion
Max date without time
I'm trying to calculate the most recent note based on a users note history. Part of that involves making sure that the date of the note ('Note Detail'[LASTDATE]) is the same date as the call ('Call ...
I just realized that I had this set up as a date type in the data view, not in the Query Editor. I switched the type there and that solved my problem.
However, is there a to keep the time and still compare just the date without having to jump through these hoops?
Hi,
In the Query Editor, you may create another column which extract the Date from the Date/time column.