Start date

[novice1]

hi,

i am using formula took to return date for the start of the year and this gives me 

2020-01-01. how can i modify this formula so my year would start on 2020-04-01?

here is the formula i am using

DateTimeTrim(DateTimeToday(), "year")

[MarqueeCrew · Accepted solution]

@novice1 ,

 let's try:

Left(DateTimeStart(),4) + "-04-01"

 cheers,

 mark

[novice1]

Thank you

🙂

[novice1]

do i just add 

"-year" to get result as 2019-04-01?

[MarqueeCrew · Accepted solution]

Hi @novice1 ,

 what's today's date?

 What was the date 1 year ago?

 What's the first 4 characters of that date?

left(datetimeadd(DateTimeStart(),-1,"year"),4)+"-04-01"

 my bad....

 cheers,

 mark

[novice1]

i am rubbish t these formulas. Still cant get it to work. sorry

can just do some sort of if statement?

[MarqueeCrew]

I edited my reply for left 4