Leap Year

Hi all,

I have the Period Start and Period End Date as I need to extract data for whole year up to and including yesterday and compare this to the same period last year.

I am using following formula to work out date today last year

DateTimeAdd(DateTimeToday(), -364, "days")

this is taking into consideration that this year is leap year. Therefore if today is Friday 11/12/2020 - same Friday last year was 13/12/2019

Everything is working as intended, except i can see issue occurring when i will need to calculate the same for non-non leap year.

Is there a way to design this flexibly, even for longer time periods?

Please see my formulas as they are at the moment down below:

New Workflow2.yxmd

Date Time

Accepted answers

Qiu

@novice1
Miss out one endif...Sorry.

novice1

@Qiu

thank you.

can you share a solved workflow please?

Now I am getting Type mismatch error.

I find date formulas quite tricky thing to get my head around.

Your help in resolving this is much appreciated.

Tyro_abc

I modified your formula slightly and it seems to be working, there were some issues with the data type. Please find the workflow attached.

The real definition of Leap Year:

The number should be divisible by 4 and Not divisible by 100. The second condition is required when the year is 1700 or 1900. That is why I used an OR condition to include those years which end with '00'. In that case, the number should be divisible by 400.

The practical definition of Leap Year:

We can only check if the number is divisible by 4, other scenario won't come anywhere between 2010 and 2099 ( more than our lifetime 🙂 )

** If you are using one formula inside another formula, then the first one needs to defined before/above the dependent formula**

New Workflow2_v2.yxmd

All comments

Qiu

@novice1

By "work out date today last year", you mean it if today is Friday 11/12/2020, you want the output to be '11/12/2019'?

novice1

hi,

no. if you look at the calendar this Friday last year was 13/12/2019.

so if i take say any given Friday in 2020 say 11/12/2021, the same Friday in 2019 would have been 13/12/2020 (extra 2 days), as 2020 is a leap year.

but if i take Friday 25/01/2019, the same Friday in 2018 was 26/01/2018 (extra 1 day).

Just trying to make my report future proof.🙂

The idea is to modify reports as little as possible once they are scheduled to run at certain times.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335