Forum Discussion
Group data as data for a month
i have a appended set of data across a few months i want to group my data such that : (dd/mm/yy) (time) 01/01/2022 10.00.00 AM - 01/02/2022 09.59.59 AM --> January 01/02/2022 10.00.00 AM ...
Anonymous , You create a new date column in your table like this that should work . You can join this with your date table and use
New Date = if(timevalues([Datetime]) <time(10,0,0) , datevalue([Datetime])-1, datevalue([Datetime]) )
amitchandak
Super User
Super UserAnonymous , You create a new date column in your table like this that should work . You can join this with your date table and use
New Date = if(timevalues([Datetime]) <time(10,0,0) , datevalue([Datetime])-1, datevalue([Datetime]) )