Marcus' answer will give you exactly that.
To expand on this a little bit, it depends on what your data format is. If your date is stored as a number then 42694 will work, however if it is stored as a date, then you will need to do it like this...
(note: use single quotes around the date.)
Or if you're using a dynamic date, something you want the user to be able to specify, the simply pre-calculate a variable with something like this...
The $(vDate) would reference a variable called vDate that you can put into an on-screen object and allow them to change or you can edit it directly with the variable overview (CTRL + ALT + V), or specify it in the load script with...
LET vDate = '20/11/2016';
LET vDate = Date(Today()-1,'DD/MM/YYYY');
If it's numerical format, then use Date#().
Hope this helps.