What is the error in my variable?

[Bobi]

Hi. Anyone who can see what the error is in my variable? I got right answer when using the YTD but this time I am substracting -1 to get last year YTD.  If i take away the 'YYYYMMDD' part I get a number. But i want it in that format and not written as 43000..

[Booking InYTD]={"$(=Date(Today())-1), 'YYYYMMDD')"}

[pepecc]

I think there is a sintax error.

Try this: Date(Today()-1, 'YYYYMMDD')

[ksgo]

It would appear the format is not within the DATE(,) and there are too many parentheses.

[Booking InYTD]={"$( =Date (Today() ) -1 ), 'YYYYMMDD' )"}