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! Go to 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"))
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! ๐
User | Count |
---|---|
37 | |
30 | |
29 | |
20 | |
18 |