Date

[provisrudd]

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/")

[Joseph_Seddik]

Use DAY() and MONTH(). 

[Suvrutt_Gurjar · 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"))

[Joseph_Seddik]

@Suvrutt_Gurjar Nice! 🙂

[App52Em]

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.