Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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')"}
I think there is a sintax error.
Try this: Date(Today()-1, 'YYYYMMDD')
It would appear the format is not within the DATE(,) and there are too many parentheses.
[Booking InYTD]={"$( =Date (Today() ) -1 ), 'YYYYMMDD' )"}