Forum Discussion
h41rd0g
8 years agoNew Member
DateBetween with Specified Date
I'm currently trying to create a function where I can take a date, say May 30, 2018 and determine if it's inbetween two dates that are already inputted into a query.
For example:
- Start date is Column 1
- End date is Column 2
I want to write an equation that would give me a T/F output that would take the May date above and determine if it is inbetween those two columns. It would probably require a < x < equation or If(And()). further I want to take that equation and apply it to a graph that would show me all the dates in the data set that would come out as true from this equation. (Sorry if that doesn't really make sense).
1 Reply
- Ashish_Mathur
Super User
Hi,
Share some data and show the expected result.