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
([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
@Knightwing thankyou! This worked perfectly!!
this is great, thankyou, if I want it to span more than one month. IE from JAN to OCT not just JAN and OCT?
this is great, thankyou, if I want it to span more than one month. IE from JAN to OCT not just JAN and OCT?
@darylwilkes0149 Easier to compute
((([MON]>1)*([MON]<=9))?100:(((((([MON]==1)*([DAY_1_31]>=25))?1:(([MON]==10)* ([DAY_1_31]<=12))))*100)))
This
For jan 25 to oct 12
For this formula
([DAY_IN_YEAR] >=298) * ([DAY_IN_YEAR] <=316)? 100:0
Look at this in this way
([DAY_IN_YEAR] >=x) * ([DAY_IN_YEAR] <=y)? 100:0
Then
Use this site
To caculate different from first jan to any date.
So example you want from jan 12 to oct 12
Caculate x = 1 jan to 12 jan how many days (11)
Caculate y = 1 jan to oct 12 how many days (316)
Therefore the correct tag is
([DAY_IN_YEAR] >=11) * ([DAY_IN_YEAR] <=316)? 100:0
1 Like
thanks. I am trying to also narrow it down to just a single day. Say 25th Dec every year, so I don’t want to use the day of the year calc as that will change every year, how to I just get it to come on the 25th of Dec every year regardless of what number day of the year that is? using the great formulas supplied I have managed to display an image over x amount of dates (if over 2 months) OR a whole month (No matter what dates I put in. So I can do certain periods if over 2 months OR a whole month. Now I just need to target a single date in the year. Thanks!
Hi, @darylwilkes0149 try using the formula
([DAY_1_31] == 5) * ( [MON]== 3)? 100:0
in the color tag (remember to put from 100 to 0) where ([DAY_1_31] == 5) is the day of the month you need and ([MON]== 3) is the month you need.
1 Like
2 Likes
Hi there, I am now having issues displaying an image for 5 days in the same month. I can get it to display for 1 day, or for a period (as long as it goes over the end of the month) But not for say 5 days in the same month, what am I missing! thanks. Daryl
Are those 5 days in row or just any random 5 days in month?
days in a row, I can do one day at a time but for some reason not more than one day in same month!! 
then it is bit easier
(([DAY_1_31]>=starting_day)*([DAY_1_31]<=ending_day)*([MON]==desired_month))>0?100:0
1 Like