Use these substitution commands in the date field: %today or %tdToday's date. For example, if today's date is February 21, 2018, then entering %td or %today is the same as entering 02/21/2018. %yesterday or %ydYesterday's date. For example, if yesterday's date was February 6th, 2018, then entering %yd or %yesterday is the same as entering 02/06/2018. %tomorrow or %tmTomorrow's date. For example, if tomorrow's date is February 8th, 2018, then entering %tm or %tomorrow is the same as entering 02/08/2018. %lastweek or %lwSubtract seven days from today's date. For example, if the current date is April 7th, 2018, then entering %lw or %lastweek is the same as entering 03/31/2018 (March 31st, 2018). %nextweek or %nwAdd seven days from today's date. For example, if the current date is April 24th, 2018, then entering %nw or %nextweek is the same as entering 05/01/2018 (May 5th, 2018). %lastmonth or %lmSubtract thirty days from today's date. For example, if the current date is April 21, 2018, then entering %lm or %lastmonth is the same as entering 03/21/2018 (March 21, 2018). %nextmonth or %nmAdd thirty days from today's date. For example, if the current date is April 21, 2018, then entering %nm or %nextmonth is the same as entering 05/21/2018 (May 21, 2018). %lastyear or %lyToday's date, but last year. For example, if today's date is February 21, 2015, then entering %td or %today is the same as entering 04/21/2014. %nextyear or %nyToday's date, but next year. For example, if today's date is February 21, 2015, then entering %td or %today is the same as entering 04/21/2016.
You can add or subtract a number of days from each adaptive date selection. For example, %td - 5 will take today's date and subtract five days. Further, %tm 20 will take tomorrow's date and add twenty days. In the United States, date formats are typically expressed in month, day, year order; however, the vast majority of the world expresses dates in the ascending order of day, month, year. For example, in the United States, 03/07/16 generally means it is the 7th of March, 2016—in the rest of the world, it means it is the 3rd of July, 2016. Be sure to configure your Setup > Localization preferences correctly. |