Smart Input Strings allow the typing of several predefined strings to enter specific DATETIME or DATE values. For instance, typing "today" results in setting the present date in the control. Typing "Friday" results in setting the date corresponding to next Friday.
Smart Input Strings are features within the DB Date And Time Edit and Variable Date And Time Edit controls, which are accepted along with entering DATETIME and DATE values using the drop-down calendar, and manually entering data into the field.
String |
Description |
bom |
Specifies the date corresponding to the first day of the current month by typing this string into the field. An acronym for "Begin Of Month". |
eom |
Specifies the date corresponding to the last day of the current month by typing this string into the field. An acronym for "End Of Month". |
fifth |
Specifies the fifth day of the current week |
first |
Specifies the first day of the current week |
fourth |
Specifies the fourth day of the current week |
Friday |
Specifies the date corresponding to next Friday |
Monday |
Specifies the date corresponding to next Monday |
now |
Specifies the current date and time |
Saturday |
Specifies the date corresponding to next Saturday |
second |
Specifies the second day of the current week |
seventh |
Specifies the seventh day of the current week |
sixth |
Specifies the sixth day of the current week |
Sunday |
Specifies the date corresponding to next Sunday |
third |
Specifies the third day of the current week |
Thursday |
Specifies the date corresponding to next Thursday |
today |
Specifies the current date |
tomorrow |
Specifies tomorrow's date |
Tuesday |
Specifies the date corresponding to next Tuesday |
Wednesday |
Specifies the date corresponding to next Wednesday |
yesterday |
Specifies yesterday's date |
Notes:
•The generated DATETIME or DATE value is based upon the Kind setting (Date or Date and Time).
•The Smart Input Strings are only recognized by the Date And Time Edit control if Input Kind is set to Standard or Regular Expression.
•Smart Input Strings can be combined with operators (e.g. "today–7" and "now+3").
