Hello, I would like to have a column with a specific value per entry when checking today’s date.
For example, if today (Feb 17) is between the given date range Feb 1 and March 15 → Return value A
If today (Feb 17) is between March 16 - April 20 → Return value B
Is this possible?
Hey Nicolas, happy to help brainstorm some ways to get this set-up in Parabola!
Here’s some step series to help get you started:
- Insert Date/Time Column, {today}
- Convert date from Step 1 to Unix
- If/Else step where if {today} is greater than unix value for Feb 1, and less than the unix value for March 15, then Return value A . If greater than unix value for Mar 16, and less than the unix value for Apr 20, then return value B
Let me know if you have any questions getting this set up.
Thanks!
Ayana
1 Like
That worked properly. Thanks.