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")
