Extracting a date

[ValeriaBonini]

Hi, in my previous script I had:

let vDateYesterday=date(today()-1, 'YYYY-MM-DD');

select 

..............

from......

where myfield >= date '$(vDateYesterday)'  and it worked fine for extracting data of 2 days ago.

Now I would like to extract data of 2 years ago and I tried 

let vDateLastTwoYears=date(addyears(today(), -2)));

select 

..............

from......

where myfield >= date '$(vDateLastTwoYears)'   but now I have this error "oracle caller interface: ora 01861: literla does not match format string"

How can I resolve?

[ValeriaBonini · Accepted solution]

Nevermind, resolved

It was: 

Let vDateLastTwoYears = date(AddYears(Today(), -2), 'YYYY-MM-DD');

[BrunPierre]

let vDateLastTwoYears=date(addyears(today(), -2)),'YYYY-MM-DD');