Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In my data I have a mix of timestamps and dates. When I floor this to try and return all entries at dates. It appears only the entries that are dates in the original data are returned. None of the timestamp entries show.
date(floor([Completed Date]),'MM/DD/YYYY') as [Completed Date]
How about this? Likewise, You need to define
date(Alt(floor([Completed Date]), Date#([Completed Date], 'mm/dd/yyyy hh:mm'),'MM/DD/YYYY') as [Completed Date]