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! 🙂
I have a similar question except I need to show January 1st of next year.
If today is 5/22/2024, then I need it to return 1/1/2025.
User | Count |
---|---|
26 | |
25 | |
25 | |
18 | |
17 |