Tip 2-1. Left Value can take all the following formats.
YYYYMMDD
YYYY-MM-DD
YYYY/MM/DD
MMDDYYYY
MM-DD-YYYY
MM/DD/YYYY
B D YYYY
B D, YYYY
D B YYYY
YYYYMMDD-HHMMSS.mmm
YYYY-MM-DD HH:MM:SS.mmm
YYYY/MM/DD HH:MM:SS.mmm
MMDDYYYY-HHMMSS.mmm
MM-DD-YYYY HH:MM:SS.mmm
MM/DD/YYYY HH:MM:SS.mmm
YYYYMMDD-HHMMSS
YYYY-MM-DD HH:MM:SS
YYYY/MM/DD HH:MM:SS
MMDDYYYY-HHMMSS
MM-DD-YYYY HH:MM:SS
MM/DD/YYYY HH:MM:SS
Tip 2-2. You can use only [+] or [-] operator.
Tip 2-3. Right Value can take only the following “time-delta” notations. There is NO SPACE after [n].
[n]day
[n]hour
[n]min
[n]sec
[n]msec
[n]usec
[n]week
[n]month
[n]year
Note: [n] is an Integer.
Tip 2-4. You can use date or datetime for the Right Value only when operator is [-].
In this case, if Left Value is date, then the Right Value must be date. If the Left Value is datetime, then the Right Value must be datetime.