SOLVED
Determine first monday of each month
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
BYoung
6 - Meteoroid
‎06-11-2021
03:23 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello,
I am looking for a way to determine the date of the first Monday of each month based on the date provided.
For example...
Date Field | First Monday of the Month |
2021-06-11 | 2021-06-07 |
2021-05-21 | 2021-05-03 |
2021-05-05 | 2021-05-03 |
2021-03-13 | 2021-03-01 |
2021-01-09 | 2021-01-04 |
The fact that monday comes on different days, and months can have 4 or 5 weeks is throwing me off.
Any ideas?
Thank you all in advance!
Solved! Go to Solution.
Labels:
- Labels:
- Date Time
- Tips and Tricks
10 REPLIES 10
apathetichell
19 - Altair
‎06-14-2021
08:31 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@BYoungThere are lots of amazing things you can do in datetime with various format options! I'm a big fan of "%u"...

- « Previous
-
- 1
- 2
- Next »