Hey guys, I am using this formula to select only tasks which were completed after a previous report up to the date of the current report. It is used in the report table.
=SELECT(Tasks[EntryID],AND([Project]=[_THISROW].[Project],[Done]=”Done”,[Date Done]>[Latest Previous Date],[Date Done]<=[Date]))
I am using a changetimestamp to register when someone selects task as done - [Date Done]. So I also made the report date [Date] and [Latest Previous Date] a DateTime column.
The problem is that it doesnt select the done or completed tasks very accurately.
I see that google sheets show the datetime without pm/am and appsheet with.
Could this be the problem? I cant find a way to make it similar. The locale is the same - United Kingdom. Any advice? Thanks lots Hyman