Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
we need to create a event calendar where i want to have a text box automatically popped up on holidays.
Like, I'm having the below table to be pulled, whenever there is a holiday i need a pop up in QV like 14/11/2018 is a holiday.
Event | Last Year Dates-2017 | Last Year Day | This Year Dates-2018 | This Year Day |
New Year | 1/1/2017 | Sunday | 1/1/2018 | Monday |
Easter | 4/16/2017 | Sunday | 4/1/2018 | Sunday |
Labour day | 9/4/2017 | Monday | 9/3/2018 | Monday |
Coloumbus day | 10/9/2017 | Monday | 10/8/2018 | Monday |
Thanks giving | 11/23/2017 | Thursday | 11/22/2018 | Thursday |
Black Friday | 11/24/2017 | Friday | 11/23/2018 | Friday |
Christmas | 12/25/2017 | Monday | 12/25/2018 | Tuesday |
Boxing day | 12/26/2017 | Tuesday | 12/26/2018 | Wednesday |
Could someone please help me with the issue.
Thanking in Advance.
Regards,
Jeshwanth
Create a text box like with show condition in the Properties->layout->show->condition
=if(Today()=EventDate ,1,0)
in expresion
==if(Today()=EventDate ,EventDate &' '&'is a holiday')
This doesn't work.:(