-
Notifications
You must be signed in to change notification settings - Fork 0
How to compare Dates
gcvfi edited this page Jan 28, 2020
·
3 revisions
Back to Excel functions | AIQ Commands | Home
Note: Draft content, work in progress, not yet reviewed or verified.
| Test Steps | Test Data |
|---|---|
| open website | https://www.google.com/ |
| Save it as date_from_screen | {Today - 1{mm}, yyyy/MM/dd} |
| Enter text | ${date_from_screen} |
| _xl{IF(TEXT(TODAY(),"yyyy/mm/dd") > ${date_from_screen}, "before today", "today or future") } as var_when_date | |
| Enter text | ${var_when_date} |
| ## another test | |
| Save it as date_from_screen | {Today + 1{dd}, yyyy/MM/dd} |
| Enter text | ${date_from_screen} |
| _xl{IF(TEXT(TODAY(),"yyyy/mm/dd") > ${date_from_screen}, "before today", "today or future") } as var_when_date | |
| Enter text | ${var_when_date} |
| ## another test | |
| Save it as date_from_screen | {Today - 1{yy}, yyyy/MM/dd} |
| Enter text | ${date_from_screen} |
| _xl{IF(TEXT(TODAY(),"yyyy/mm/dd") > ${date_from_screen}, "before today", "today or future") } as var_when_date | |
| Enter text | ${var_when_date} |
| ## another test | |
| Save it as date_from_screen | {Today, yyyy/MM/dd} |
| Enter text | ${date_from_screen} |
| _xl{IF(TEXT(TODAY(),"yyyy/mm/dd") > ${date_from_screen}, "before today", "today or future") } as var_when_date | |
| Enter text | ${var_when_date} |
| ... | ... |
-
User Guide HTML (V1.3)
-
AutonomIQ NLP commands (V1.0 - Old)
-
AIQ Commands wiki (new draft)
-
AIQ User Guide wiki (new draft)
-
Release Notes wiki (new draft)