| Variables v:VariableName(x) | There are several options to search for variable dates. Start each variable with v: to tell Sequenchel you wish to use a variable. |
| You can add several options between the brackets of date/time variables:(x), (Year,x), (Month,x), (Week,x), (Day,x), (Hour,x), (Minute,x), (Second,x), (Millisecond,x) x is the number to add, -x is the number to subtract. These options can be used with every date/time variable. Illegal values or options will be ignored. Every variable has a default option for when only a value is entered. | |
| v:Now() | This means the current date and time. |
| The default value for add/subtract is Hour. | |
| v:Now(5) means 5 hours ahead. | |
| |v:Now(-3) means 3 hours in the past. | |
| v:Now(Day,2) means current date and time plus 2 days. | |
| v:Now(Year,-3) means current date and time minus 3 years. | |
| v:Date() | This means today (date only, no time). The default value for add/subtract is Day. |
| v:Time() | This means the current time (no date). The default value for add/subtract is Minutes. |
| v:MonthStart() | This means the first of the current month (date only). The default value for add/subtract is Month. |
| v:MonthEnd() | This means the last day of the current month. The default value for add/subtract is Month. |
| v:WeekStart() | This means the Monday (first workday) of the current week. The default value for add/subtract is Week. |
| v:WeekEnd() | This means the Sunday (last day) of the current week. The default value for add/subtract is Week. |
| v:YearStart() | This means the first day of the current year. The default value for add/subtract is Year. |
| v:YearEnd() | This means the last day of the current year. The default value for add/subtract is Year. |
| f: | You can also use functions. A function is any valid SQL query, preceded by f: |
| f:SELECT TOP 1 value FROM tbl_Orders | |
| f: SELECT DATEADD(MONTH,2,DATEADD(DAY,-DAY(getdate())+1,DATEADD(day, DATEDIFF(DAY,0,GetDate()),0))) | |
| [this means 2 months in the future from the first day of the current month; this is the same as v:MonthStart(2) ] |