How do we view “Day of the week” within a report for time entered in Web TimeSheet?
Find resources designed to help you get the most from Replicon
Scenario:
Time is entered within a TimeSheet and a Time report is ran to view the data. However, the report does not show the day of the week. Is it possible to show the day when time was entered?
Resolution:
Create a custom column with the following formula. This formula will help in showing the day when time was entered.
(IF((MOD((Daydiff((date(1990,1,7)),EntryDate)),7))>3,(IF((MOD((Daydiff((date(1990,1,7)),EntryDate)),7))=6,"Saturday",if ((MOD((Daydiff((date(1990,1,7)),EntryDate)),7))=4 , "Thursday" , "Friday"))),(IF((MOD((Daydiff((date(1990,1,7)),EntryDate)),7))>=0 &&(MOD((Daydiff((date(1990,1,7)),EntryDate)),7))
< 3 ,(IF((MOD((Daydiff((date(1990,1,7)),EntryDate)),7))=0 ,"Sunday" ,IF((MOD((Daydiff((date(1990,1,7)),EntryDate)),7))=1 , "Monday" ,"Tuesday"))),"Wednesday"))))