To display an image on a certain date

Hi all,

I want to display an image for a certain period within a year. For example, from the 25th of Oct through to the 12th of Nov., How can I do this? What complication do I need to use? thanks.

use tag on the color %
on your image.

use the

((([MON]>=10)*([MON]<=11))?0:-100)

this is show image if its in the month oct and nov.

i can only figure a quick formula for btw months. but down to date need more time.

Hi, @darylwilkes0149 first of all you have to calculate the number of days that must remain visible.
The simplest calculation is using Excel as in the example:

Data 1 Data 2 Giorni
25/10/2024 - 01/01/2024 298
12/11/2024 - 01/01/2024 316

Where you subtract the first initial date you need from January 1st in order to have the number of the day (example 25/10/2024 corresponds to 298), do the same for the second final date to have the second n. (example 12/ 11/2024 corresponds to 316).
Then select your image and in the color section, insert 0% instead of 100% and on the tag put the following formula

image

([DAY_IN_YEAR] >=298) * ([DAY_IN_YEAR] <=316)? 100:0

Where obviously 298 is the no. of the first useful day to be displayed and 316 is the n. of the last useful day to display. Remember that there are years that have February 29th… like this year and the formula does not take it into account.

Hi, try this simple formula.

((((([MON]==10)*([DAY_1_31]>=25))?1:(([MON]==11)*([DAY_1_31]<=12))))*100)

1 Like