I need to test sample dates throughout the year to see if my expression with a lot of today() elements works as expected. Any idea on how to test this?
Could you update if you have several expressions involving TODAY() and where these are used?
Yes, and on 3 different apps. But Iโd like to test only 1 expression, which has many today() elements.
Thank you.
One approach I would try is, in all those elements, I would replace TODAY() with USERSETTINGS(TodayCheck). Here [TodayCheck] is a date type column in USERSETTINGS
I would keep changing values of [TodayCheck] in USERSETTINGS. After successful debugging and testing, I would again replace USERSETTINGS(TodayCheck) back to TODAY()
So in an expression IF ( [Delivery Date]>TODAY() , โOkayโ, โPast Delivery Dateโ) , I would test with
IF ( [Delivery Date]>USERSETTINGS(TodayCheck) , โOkayโ, โPast Delivery Dateโ)
Neat! Thank you!
I have a scratch pad โappโ or table which I use with the expression eval โTestโ button.
So you could manually create those TODAY
values in a table and simply write the same expression and press โTestโ button under expression editor.
Hmmโฆ I was hoping for a simpler solution. But good idea if that is all that can be done
User | Count |
---|---|
42 | |
34 | |
27 | |
23 | |
16 |