AsDate Expressions
| Expression
|
Databox Value
|
Result
|
Comments
|
| AsDate
|
"15-10-2018 08:00pm"
|
15/10/2018 20:00:00
|
A date entry is converted into a simple date format
|
| AsDate Format ("ddd dd MMM yyyy - HH:mm")
|
"15-10-2018 08:00pm"
|
Mon 15 Oct 2018 - 20:00
|
A date entry is formatted to the required layout
|
| AsDate Format (‘d’)
|
"15-10-2018 08:00pm"
|
15/10/2018
|
A date entry is converted into day/month/year
|
| AsDate Format (‘dd’)
|
"15-10-2018 08:00pm"
|
15
|
A date entry is converted into day of the month
|
| AsDate Format (‘ddd’)
|
"15-10-2018 08:00pm"
|
Mon
|
A date entry is converted into short name for day
|
| AsDate Format (‘dddd’)
|
"15-10-2018 08:00pm"
|
Monday
|
A date entry is converted into full name for day
|
| AsDate Format (‘D’)
|
"15-10-2018 08:00pm"
|
15 Oct 2018
|
A date entry is converted into day month year (with short month name)
|
| AsDate Format (‘m')
|
"15-10-2018 08:00pm"
|
15 Oct
|
A date entry is converted into day month (with short month name)
|
| AsDate Format (‘mm')
|
"15-10-2018 08:00pm"
|
00 (minutes)
|
A date entry is converted into the minutes past the hour
|
| AsDate Format (‘MM’)
|
"15-10-2018 08:00pm"
|
10
|
A date entry is converted into the month
|
| AsDate Format (‘MMM’)
|
"15-10-2018 08:00pm"
|
Oct
|
A date entry is converted into the month (with short month name)
|
| AsDate Format (‘y’)
|
"15-10-2018 08:00pm"
|
Oct 2018
|
A date entry is converted into month year (with short month name)
|
| AsDate Format (‘yy’)
|
"15-10-2018 08:00pm"
|
18
|
A date entry is converted into final two numbers of the year
|
| AsDate Format (‘yyy’)
|
"15-10-2018 08:00pm"
|
2018
|
A date entry is converted into the year
|
Other Date Expressions
| Expression
|
Databox Value
|
Result
|
Comments
|
| After("14-10-2010")
|
"15-10-2010 08:00pm"
|
True
|
Any time part of the date is ignored
|
| Before("14-10-2010")
|
"15-10-2010 08:00pm"
|
False
|
Any time part of the date is ignored
|
| BetweenDates ("15-10-2010",Today)
|
"15-10-2010 08:00pm"
|
True
|
Will compare inclusive of the dates used (ignoring time). Can be arranged in any order e.g. BetweenDates(Today, "15-10-2010") or - replace Today with a date e.g. BetweenDates(“15-10-2010”,”23-10-2010”)
|
| AsDate Format(‘HHmm’) AsNum Between(0800,1530)
|
"15-10-2010 08:00pm"
|
False
|
Will compare two times and check if the current time is within them
|
| DateAdd(12,"m")
|
"15-10-2010 08:00pm"
|
15/10/2011 20:00:00
|
Intervals: s - seconds, n - minutes, h - hours, d - days, m - months, q - quarters, ww - weeks, yyyy - years
|
Returning Numerics Now/Today
| Expression
|
Databox Value
|
Result
|
Comments
|
| Day
|
"15-10-2010 08:00pm"
|
15
|
Will show the day as a Numeric result only
|
| Month
|
"15-10-2010 08:00pm"
|
10
|
Will show the month as a Numeric result only
|
| WeekDay
|
"15-10-2010 08:00pm"
|
6
|
Will show the weekday as a Numeric result only. Sunday will count as day 1 – Saturday, day 7
|
| Year
|
"15-10-2010 08:00pm"
|
2010
|
Will show the year as Numeric result only
|
| Now
|
Current date and time is:
|
Current date and time is: 15 Oct 2010 - 20:00
|
&Format(Now, "dd MMM yyyy - HH:mm") Returns the present Date and Time
|
| Today
|
Current month and year:
|
Current month and year: Oct 2010
|
&Format(Today, "MMM yyyy") Returns the present Date and Time
|
