Skip navigation

BETWEEN function

score 107
You have not voted. Active

Here's a function that would be quite helpful: BETWEEN

 

It may work similarly to how it does in SQL Server. It could be used to compare 2 numbers, dates, etc

 

Anybody agree with me?

 

In pseudo code:

if DATEDIFF('day',[InvoiceDate],Today()) BETWEEN 30 AND 60 then "Overdue"

else "Foobar"

end

Comments