Date range BETWEEN doesn't include last date

#21

Me too! :slight_smile:

#22

Now imagine if we can figure it out so that we could combine both IF’s and bridge both years with one statement! :wink:

#23

I’m trying to think how to do one for BST/GMT.
I need to use Last Sunday in Oct and Mar but cannot do it.

#24

This seems to do it in one statement across the ‘year boundary’. I’ve tried true and false conditions with some success. The only limitation with it as written is Christmas season couldn’t start before 12/3. But if that’s a problem, this could be made to work with some additional tweaking (such as adding Month Name):

image
image.png1178×494 24.6 KB

#25

I’m out running errands right now so I can’t do it, but was just thinking and there’s a simpler way to do it. Instead of using $day < 3, use $monthName = ‘January’ and there won’t be any restrictions with the date it can start in December.

#26

@PrometheusXex @bobbles

Here’s the one using Month name. If you don’t want to hard-code the dates in the IF statement, it’d be easy to add a DecemberStart and JanuaryEnd integer and plug them in where the 15 and 3 are written now.

image
image.png1178×511 25 KB

#27

If I may ask… what exactly does the ? mean?

#28

It’s the condition structure.

Condition ? When True : When False

#29

Thanks for the extra information.
I’ll leave as 2 separate statements that make sense to me. :smile: