First monday of the month
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi ,
Is there a way to calculate or check if today is the first monday of the month .
Thanks
Solved! Go to Solution.
- Labels:
- Date Time
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Nandakishore yes this can be done with logic
adding workflow for reference.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Nandakishore take a look a this workflow it should help
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You can use the following in a Formula tool. Replace the [DateTime_Out] with your date field. This will give you the first Monday of any month. You can combine this with an IF statement to see if today is the first Monday of the month.
datetimeadd(datetimeparse(datetimeformat([DateTime_Out],"%Y-%m")+"-01","%Y-%m-%d"),mod(8-tonumber(datetimeformat(datetimeadd([DateTime_Out],-tonumber(datetimeformat([DateTime_Out],"%d"))+1,"days"),"%u")),
7),"days")
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Nandakishore,
I would use a formula tool to check whether the specific date is Monday and it is less or equal the 7th day of the month. Please refer to below screenshot
 
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
missed adding workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Nandakishore
i think i complicated it
other solutions are easier to use
![](/skins/images/9780FA8738778E76CAA545EFAA4CDA4D/responsive_peak/images/icon_anonymous_message.png)