Show_If

[provisrudd]

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?

[SkrOYC · Accepted solution]

WEEKDAY(TODAY())=2

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

[Marc_Dillon]

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

[provisrudd]

Hi

I tried reading through the manual but I still cant find the answer. 

[SkrOYC]

What have you written and doesn't work?

[SkrOYC]

Yeah, it's not that hard.

You just need to read the manual as @Marc_Dillon said

[provisrudd]

I have tried the following but it still isn't working

DAY(TODAY())="Monday"=YES

[Ratatosk]

I don't understand. What do you want to achieve?

Day today equals text monday equals yes, does not mean anything.

[graham_howe]

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.

[SkrOYC · Accepted solution]

WEEKDAY(TODAY())=2

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

[provisrudd]

Hi,

I actually tried this and my show_if expression doesnt show on mondays?

[Ratatosk · Accepted solution]

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.