Solved: How to add date wise data on each slice? - Page 2

Amazon_Infinite · 05-23-2021 09:50 AM

I make 3 slice each for today yesterday and this week.
I put the formula of:
Today 》 ([Date] = TODAY())
Yesterday 》 ([Date] = TODAY()-1)
This week 》 WEEKNUM([Date])= WEEKNUM(TODAY())
But they are not working and,

I also tried with Greater and less than. But it was not using correctly.

Help me out what i do now😐

@Steve

Guy_Merlin_Dyan

@Amazon_Infinite ,

Make sure that the date format is of the type “Date” and not “Date time”

if this is the case, wrap it in the function: Date (), or you separate the date from the hours
and cancels the counting of seconds

View solution in original post