isamudysan

calculations for days of week

Discussion created by isamudysan on Nov 27, 2015
Latest reply on Nov 27, 2015 by isamudysan

i'm currently working on a attendance solution for my work place.  one of the criteria for this solution is to have a drop down calendar, which when the date is selected will auto populate the day names of the week as well as the dates for that week.  the starting day, or day 1, is sunday. so, on any given day when a record is created/or selected, the day 1 field should always be sunday of that work week. the date field type is 'Date'.

 

what i currently have is below (with calculations):

attendance.png

and calculations are as follows:

day_calc.png

the fields Day1Date (and so forth) has the calculation of Date - 1, Date - 2, etc., etc.

 

any help and assistance is greatly appreciated. thank you in advance.

Outcomes