IF Statement with Dates
- 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
Hello community,
I am looking to have a formula that says: "If the [Date] is equal to or greater than the 11th of the prior month, then "New Item". Today is 2022-09-28
Date | Comment |
2022-09-02 | New Item |
2022-08-11 | New Item |
2022-08-09 | "Leave blank" |
The formula needs to be dynamic. Thank you :)
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you @binuacs - it worked for my situation!
I understood how the formula works except for the "7". I might have to use something similar in the future and I want to grasp it ;)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Kristie_Pires Let me explain the formula in detail
Left(toDate(DateTimeAdd(DateTimeToday(),-1,'Month')),7)+'-11', 'New Item','')
DateTimeAdd(DateTimeToday(),-1,'Month') - will return the previous month
ToDate() - function will convert the above DateTime value to just Date value (The time part will be ingnored)
Left() - function used to take from left to 7 character length. For example Left('2022-09-02',7) returns first 7 characters i.e 2022-09
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you both for helping me out! @binuacs Thanks for explaining so that I can replicate the formula in the future 😊
