Forum Discussion

h41rd0g's avatar
h41rd0g
New Member
8 years ago

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