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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Getting the Monday date from a week number 1

Status
Not open for further replies.

TomSalvato

Technical User
Mar 24, 2010
64
0
6
US
Good morning, Experts.

Hopefully there's an easy way to do this. I'm trying to create an expression in builder.
I have a 'Week Number' field (which is just what it sounds like, the week number of the year for that record).
I'd like to get the Monday date for that week number.

For example:
if the week number is 18 (which is this week), then I'd like to return 04/29/2024.
if the week number is 17, then I'd like to return 04/22/2024.

* if it makes it any easier, I also have the specific date for each record in a date field.

Thanks in advance!
 
=DateAdd("ww",[WeekNumber]-1,DateSerial(2017,1,2))
 
Perfect. Thanks so much, strongm!

Slight modification to the DateSerial function for my needs.
Here's the final formula for anyone else that may someday be looking at this ...

MondayDate: DateAdd("ww",[My_Table]![Week Number]-1,DateSerial(Year([date]),1,1))

* Putting the Year function within the DateSerial function should alleviate the need to hardcode the year every January. -TS
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top