Hello,
Im trying to add in a show_if based on the last entry date plus six months? Is this possible?
And a show_if expression to show a question only on mondays?
Yeah, it’s not that hard.
You just need to read the manual as @Marc_Dillon said
1 Like
Hi
I tried reading through the manual but I still cant find the answer.
What have you written and doesn’t work?
1 Like
I have tried the following but it still isn’t working
DAY(TODAY())=“Monday”=YES
I don’t understand. What do you want to achieve?
Day today equals text monday equals yes, does not mean anything.
2 Likes
First of all the DAY() function returns the day number within the month (1 to 28/30/31 depending on month). What you need is the WEEKDAY() function. Take a look at the following article in the help documentation.
|
| WEEKDAY() |
| - | - |
| | Day of week from Date or DateTime |
Also you don’t need the second ‘=’ sign to determine if it is true.
3 Likes
WEEKDAY(TODAY())=2
1 Like
Hi,
I actually tried this and my show_if expression doesnt show on mondays?
It should work.
WEEKDAY(TODAY())=2
“2” is monday, “3” is tuesday etc.
You can temporarily add a virtual column with a date in it to test different dates, and replace TODAY() in the example above with that virtual column.
2 Likes