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:

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