Customer Zone

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

Home Customer Zone Support How do we view “Day of the week” within a report for time entered in Web TimeSheet?

This article is part of the Replicon Gen2 knowledge base. If you’re looking for information on Replicon Gen3, which is the latest version of Replicon, please visit:

https://www.replicon.com/help/

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