This is a functional version of the Get Specific Date feature.
Valid arguments are one of the following:
"Today"
"Yesterday"
"Tomorrow"
"Earlier this month"
"End of month"
"Early last month"
"Last day of last month"
"Early next month"
"Last day of next month"
"Early this year"
"End of year"
"Early last year"
"End of last year"
"Early next year"
"End of next year"
"First day of the fiscal year"
"Last day of the current fiscal year"
"First day of last fiscal year"
"Last day of last fiscal year"
"First day of the next fiscal year"
"Last day of next fiscal year"
= getdate("Yesterday")