Date

Did I do this Show_if expression correctly? I only wanted a question to show on jan 1, jun 6 and dec 12th of every year.

 

OR(Today()="01/01/",Today()="01/06/",Today()="01/12/")

Solved Solved
0 3 159
1 ACCEPTED SOLUTION

To add another option to @Joseph_Seddik guidance, you could explore TEXT() functions for formatting dates ,times and numbers as text strings.

https://help.appsheet.com/en/articles/3517328-text

https://help.appsheet.com/en/articles/2357277-in

Your Show_if expression could then be something like 

IN(TEXT(TODAY(),"DDMM"), LIST("0101", "0106", "1212"))

View solution in original post

3 REPLIES 3

Use DAY() and MONTH(). 

To add another option to @Joseph_Seddik guidance, you could explore TEXT() functions for formatting dates ,times and numbers as text strings.

https://help.appsheet.com/en/articles/3517328-text

https://help.appsheet.com/en/articles/2357277-in

Your Show_if expression could then be something like 

IN(TEXT(TODAY(),"DDMM"), LIST("0101", "0106", "1212"))

@Suvrutt_Gurjar Nice! ๐Ÿ™‚

Top Labels in this Space