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:
Solved! Go to Solution.
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.
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**