Joined: 04 Oct 2016
Online Status: Offline
Posts: 24
Topic: Formula Help - Group by week Posted: 24 Oct 2018 at 10:28am
I have the following formula to group by week
starting on Friday. Currently it is set to convert the date "totext".
How can I change the formula to leave as a date rather than text? This
way I can run multiple years and the week groups will be in
chronological order. TIA
local datetimevar start;
local datetimevar end;
start:= {unithist.onduty}-weekday({unithist.onduty},6)+1;
End:=start+6;
totext(start,"MM/dd/yy") & " - " & totext(end, "MM/dd/yy")
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum