Calculating the number of days since year start

Martin Hazell_psk0k1

I am trying to calculate the number of days since the start of the year in an automation, and am struggling to get it to calculate correctly.

I have tried various ways of doing it, and now have two variables:

YearStart: {{now.startOfMonth.withMonth(1)}}

NumberofDays: {{now.diff({{YearStart.toDate}}).days}}

When running it I get an error: Failed to get value for now().diff({{YearStart.toDate: {{now().diff({{YearStart.toDate}}).days}}

I am at a loss as to what to try next.

Evgenii

Hi, @Martin Hazell 

Welcome to Atlassian Community

Try this formula. It works

{{YearStart.toDate.diff(now).days}}

I used variable YearStart like yours, but if you want, you can use such smart value, it will take 1 month, 1-st day, 1 minute.

{{now.startOfMonth.withMonth(1).withHour(0).withMinute(0)}}

Action details:
Log action
Log
YearStart: 2024-01-01T21:29:07.7+0000
Log action
Log
NumberofDays: 8

---