Skip to main content

I would appreciate any input for such task:

I need to determine if TODAY() falls within a date range, say from March 1st to October 31st, regardless of the year.

So I need to compare TODAY() with start date and end date without the year, but only with day and month.

I cannot figure out how to do it.

Thanks for any thoughts

Does this look right?

AND(
  OR(
    IS_SAME(
      Today,
      DATETIME_PARSE(
        '01 Mar ' & YEAR(Today)
      ),
      'day'
    ),  
    IS_AFTER(
      Today,
      DATETIME_PARSE(
        '01 Mar ' & YEAR(Today)
      )
    )
  ),
  IS_BEFORE(
    Today,
    DATETIME_PARSE(
      '01 Nov ' & YEAR(Today),
      'DD MMM YYYY'
    )
  )
)

And I’ve set it up here for you to check out!

 

Thank you ​@TheTimeSavingCo , that’s exactly what I was looking for.

Appreciated your help very much indeed

Reply


Terms & Conditions