What is the correct syntax for the following:
I am trying to write a query which evaluates whether today's date is between two dates - - if so, then perform a calculation, else Null. I'm having trouble with the date syntax.
This is what I have tried:
Expr: IIf(Date() > #[BeginningDate]# and < #[EndingDate]# , [PerformCalculation] ,Null)