Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a table of counts over the last 7 days, sorted mon tues wed...etc
is there a way of sorting by today onwards, So today is Thursday - start the sort on Friday
thanks
Hi
you could try in this way
Expression:
If(weekdayn>=$(DayToday), weekdayn-$(DayToday),$(DayToday)+1+weekdayn)
you need to
1) create the variable
DayToday = Num(Weekday(Today()))
2) create a field (or you could use the expression instead of weekdayn)
Num(WeekDay(date)) as weekdayn