
Creator
2018-11-21
02:58 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
if date is between two dates (formula)
Good afternoon all,
I'm trying to create a formula that returns a 1 if the [Start Date] falls between two dates [Entry Date] and [Exit Adjusted Date]. I came across a different post regarding use of interval match. All I could find is load script information.
Thanks
4 Replies

Partner - Master III
2018-11-21
04:02 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Do you mean on UI or a chart?
Why not if(startdate >entrydate and startdate<exitdate, 1,0)
Interval match is a script level function
Why not if(startdate >entrydate and startdate<exitdate, 1,0)
Interval match is a script level function
18,660 Views

Creator
2018-11-21
04:08 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
UI, didn't know that interval match is only a script function.
18,654 Views
2018-11-21
07:21 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this?
If([Start Date]<=[Entry Date] and [Start Date]<=[Exit Adjusted Date],1)
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

Specialist II
2018-11-21
10:10 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
try like this.. If (StartDate>=EntryDate and StartDate<=ExitDate,' 1','0') as Date_Flag
18,627 Views
