Forum Discussion

georgec96's avatar
georgec96
Icon for Helper II rankHelper II
4 years ago

Time filtering

Hi everyone    I have a transaction table with a few million rows and a date&time column that contains records for several days.   Because the data gets pulled at a random time, some of my record...
Need Help
Tips and Tricks
Tutorial Requests
mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
4 years ago

I agree you should split your DateTime into Date and Time columns (best practice). You could then add a custom column that returns 1 if the Date is today ( Date.From(DateTime.LocalNow()) ) and the hour is >=6, and 0 if not. You can then filter away the 1s.

Pat