Hey Peeps (again),
In this other piston, it’s my Christmas Season piston. It assigns a variable to True or False. It’s been fine up untill today. It set FALSE because this is the last day in the BETWEEN range. Can this be modified to include today in that range? Would the end date work if WebCoRE instead see a range of:
Date is between { ’ Dec 1, { $year } ’ } and { ’ Jan 2, { $year }+1 ’ }
Cheers
Why not just set your end date to tomorrow so today is “between” your beginning and end dates?
Edit to add: when you enter a date in any “between” formula, you have to imagine there is a 12:00 midnight stamp right behind it. That’s why your first condition included January 1st (because any time after midnight met it) but you have a dead spot between 12/31 at midnight and 1/1 at midnight.
Just change it to 12/1 thru 1/1 (or 12/1 thru 12/31 at 11:59:59 if you’re struggling with the year issue).
If I use your suggestion, it should work, but it removes the ability to change what part of December is the initial start.
In the end I might be overthinking this. It’s probably easier to just create a virtual Christmas switch, or set the @IsItChristmasSeason variable manually.
I like this method as long as it runs on it’s own each year. I tried coding it, but can’t seem to be able to code in the TIME for the last day in Dec.
Expression:
‘Dec 31, {$year}’
How do I add the time in that?
Date is between { ’ Dec 1, { $year } ’ } and { ’ Jan 2, { $year }+1 ’ }
which the intended result is maybe?
Date is between Dec 1, 2017 AND Jan 2, 2018
BTW I really like my idea of this Date is Between, but came to the conclusion it wouldn’t work due to the fact that once the year rolled over, the Dec year would also be changed in the IF. This would then become
Date is between Dec 1, 2018 AND Jan 2, 2018
At least that’s what I think.
It would work perfectly. The challenge is to make it open-ended enough that it doesn’t need editing every year. It’s more of an exercise of actually beating it and getting it to work as intended… without cheating. Otherwise since I would have to go in every year to alter the date, then I might as well just set the variable manually and be done with it. No fun in that… LOL.
So would the expression be something like this?
‘Dec 31, {$year}, 23:59:59’
EDIT: Modified the statement…
Not sure to be honest.
I was thinking this but I can’t say for sure.
EDIT.
With the time.
I’m not sure, but I think mine might work.
I initially did (notice where I put the last single quote)…
‘Dec 31, {$year}’, 23:59:59
… but noticed an expression error in the logs.
When I changed it to (notice where I put the last single quote now)…
‘Dec 31, {$year}, 23:59:59’
… the error disappeared.
If I’m right, it seems the simplest.
