Date Expressions

From Keyfax Wiki
Jump to: navigation, search


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