Selects records based on a date or range of dates.
DATE(date1[,date2]|TODAY|-nn)
Is a base Julian date (yyddd). If you specify only one date, records produced on or after that date are selected.
Is a limiting Julian date (yyddd). If you specify two dates, records produced on and between those dates are selected.
Note: To select records produced on a single day, specify date1 equal to date2.
If you specify TODAY, then the Julian date for this day is substituted.
If you specify -nn, where nn is a value from 00 to 99, then the Julian date subtracted from the current date is used, and a report is produced including records from the selected date to the current date. For example, DATE(-01) means yesterday and today; DATE(-00) is today. DATE(-02,-01) is the day before yesterday thru yesterday.
|
Copyright © 2009 CA.
All rights reserved.
|
|