What is the tag to display the number of the next day, for example, May 1st when it is April 30th?
2 Likes
You have to do some Jiggery Pokery .
DAY_1_31==DAYS_IN_MON?1:DAY_1_31+1
2 Likes
Thanks Peter . I had to test it . This works for me .
Format protected .
.
([DAY_1_31]==[DAYS_IN_MON]?1:[DAY_1_31]+1)
Thanks Peter, It works for me.
1 Like
Paying this forward here… i do not remember who posted this or which topic it was under or even how long ago it was, but i got this code from someone here (a big thank you to this forum/community!) that takes into account for leap years.
for minus 1 date:
(([DAY_1_31])-1==0? ((([DAY_1_31]-1)==0)*((([MON]-1)==0)*31))+((([DAY_1_31]-1)==0)*((([MON]-1)==1)*31))+((([YEAR]%4)==0? (([DAY_1_31]-1)==0)*((([MON]-1)==2)*29):((([DAY_1_31]-1)==0)*((([MON]-1)==2)*28))))+((([DAY_1_31]-1)==0)*((([MON]-1)==3)*31))+((([DAY_1_31]-1)==0)*((([MON]-1)==4)*30))+((([DAY_1_31]-1)==0)*((([MON]-1)==5)*31))+((([DAY_1_31]-1)==0)*((([MON]-1)==6)*30))+((([DAY_1_31]-1)==0)*((([MON]-1)==7)*31))+((([DAY_1_31]-1)==0)*((([MON]-1)==8)*31))+((([DAY_1_31]-1)==0)*((([MON]-1)==9)*30))+((([DAY_1_31]-1)==0)*((([MON]-1)==10)*31))+((([DAY_1_31]-1)==0)*((([MON]-1)==11)*30))+((([DAY_1_31]-1)==0)*((([MON]-1)==12)*31)):[DAY_1_31]-1)
Plus 1 date:
(([MON]==2)?((([YEAR]%4)==0)?((([DAY_1_31])==29)?1:([DAY_1_31]+1)):((([DAY_1_31])==28)?1:([DAY_1_31]+1))): (([MON])==1)?((([DAY_1_31])==31)?1:([DAY_1_31]+1)): (((([MON]>=3)*([MON]<=7))*(([MON]%2)==0))+ ((([MON]>=8)*([MON]<=12))*(([MON]%2)>0))? ((([DAY_1_31])==30)?1:([DAY_1_31]+1)):((([DAY_1_31])==31)?1:([DAY_1_31]+1))))
Cheers!
*edit to say, i tried copying and pasting my code above to check my work and for some reason the minus 1 date doesn’t show properly when the date is the first. but it works from where i copied it from. it must be a format thing since it works from the edit window just not once it posts.
*edit to the edit - attempt to format protect for copy and paste
2 Likes
Yes Formuas posted here need format proecting . Select it and hit </> . This seems to be unnecessary on a Mobile .
1 Like
@RickyGrafixWF . Yeah your formulas work fine but I get confused with the Leap stuff . All the formulas show cover Leap Year .
it wasn’t my code.
as i said, i can’t remember where it came from but it is not my formula. way too smart for me!
1 Like
i found the original post from feb 2024
*edit credit to @Knightwing
3 Likes
Yes, the -1 date may need compensation for that, and works the way in that earlier thread, but the one I put here, for the plus one in question, should do that too as is, without extra compensation needed.
1 Like
[DAYS_IN_MON] new tag?
When i did this formula i think it was not available
Anyways good tag
2 Likes
They change something every Update . So we try them to see and find out it is too Buggy to use . Then we have a load of work that can not be used on the Previous . So we wait for the next one and go through the whole process again . No one person can keep track of all the Before and After changes . We are fortunate that there are a few makers that use certain bits of the Platform and let us Know . I myself am into the Moon and Gyro . They have not had much change in a few years . I am just looking forward to Sunrise and Sunset times . Perhaps Lat and Lon .
