Show_If

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?

https://help.appsheet.com/en/articles/961346-date-and-time-expressions

3 Likes

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

https://help.appsheet.com/en/articles/2357328-weekday

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