admin 8/21/2018 | |
Your IF condition misses parenthesis around it. Please refer to examples in the manual: |
R
|
rlmartinez 8/22/2018 |
Thank you. I added the parenthesis and now I'm getting the following error message: |
A
|
Arkie 8/22/2018 |
I always had a bad time with date stuff, so I learned to do the calcs in a query; such as |
admin 8/22/2018 | |
datetime.now(-30) is meaningless. See this for inspiration: |
R
|
rlmartinez 8/30/2018 |
Thanks Joe. I went with your approach and ended up using DateDiff. |