Wrong formula? Only funtion

[Theo_Westseit]

Hello Guys,

im struggling with this formula, which is unfortunately not working:

=Only({<Month={"$num(month(If(((Today()-Monthstart(Today())))<'3',Date(Monthend(Today(),-2)),Date(Monthend(Today(),-1)))),'00')"},Year={"$num(year(If(((Today()-Monthstart(Today())))<'3',Date(Monthend(Today(),-2)),Date(Monthend(Today(),-1)))),'0000')"}>} Message)

If i replace the formula with numbers-> Month={ '05'}, Year={'2022'}, then it works perfectly...what do i need to change?
Thanks guys!

[vchuprina · Accepted solution]

Hi,

Try this:

=Only({<Month={"=num(month(If(((Today()-Monthstart(Today())))<'3',Date(Monthend(Today(),-2)),Date(Monthend(Today(),-1)))),'00')"},
         Year={"=num(year(If(((Today()-Monthstart(Today())))<'3',Date(Monthend(Today(),-2)),Date(Monthend(Today(),-1)))),'0000')"}>} Message)

I've replaced $ by = and it works for me

Regards,

Vitalii

[Theo_Westseit]

Thanks so much! 😀