Calculate Days between date and last sundays date 1

[aarondewberry]

All

I need to calculate the number of days between a date (ie. 03/07/06) and last sundays date. So if I ran the report today, it would still only show the amount of days between the 1st date up to last sunday (ie. 13 as above).

Hope this makes sense.

 

[BrianTyler]

=DayNumberOfWeek(CurrentDate())

will give the day number of the week (Sunday is day 0)


=CurrentDate()-DayNumberOfWeek(CurrentDate())

will give Sunday's date

=DaysBetween(<Date of Birth> ,CurrentDate()-DayNumberOfWeek(CurrentDate()))

wil give days from first date to lastSunday

 

[aarondewberry]

Thanks Brian

Works a treat!!