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