Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Display date as first day of the week for last 5 weeks
- Thread starter c83user
- Start date
(_day_of_week([some_date],1) = 1 and _week_of_year([some_date]) = _week_of_year([current_date]))
or
(_day_of_week([some_date],1) = 1 and _week_of_year([some_date]) = _week_of_year([current_date])-1)
based on ISO standard 8601 that day 1 of the week is a monday
Ties Blom
or
(_day_of_week([some_date],1) = 1 and _week_of_year([some_date]) = _week_of_year([current_date])-1)
based on ISO standard 8601 that day 1 of the week is a monday
Ties Blom
- Status
Similar threads
- Locked
- Question