Date
Syntax:
_Date()
Purpose: Returns the current date in short format.
Example:
_Print_Console(_Date())
Output: 11/11/2023
Date_Add_Days
Syntax:
_Date_Add_Days(anyDateTime1,
nDays)
Purpose: Adds a specified number of days (can be decimals) to a given DateTime value.
Example:
_Print_Console(_Date_Time())
Output: 11/11/2023 1:12:12 AM
_Print_Console(_Date_Add_Days(_Date_Time(),
28.5))
Output: 12/09/2023 13:12:12
Date_Diff
Syntax:
_Date_Diff(anyDateTime1,
anyDateTime2)
Purpose: Calculates the difference in days between two DateTimes (format must include AM or PM).
Example:
anyDateTime1
= _Date_Time()
anyDateTime2
= "11/04/1994 07:00:00 AM"
_Print_Console(_Date_Diff(anyDateTime1,
anyDateTime2))
Date_Diff_Mins
Syntax:
_Date_Diff_Mins(date1,
date2)
Purpose: Calculates the difference in minutes between two dates (requires "YYYY-MM-DD HH:MM AM/PM" format).
Example:
anyDateTime1
= "1994-11-04 07:00 AM"
anyDateTime2
= "1968-04-30 05:00 PM"
_Print_Console(_Date_Diff_Mins(anyDateTime1,
anyDateTime2))
Date_Substract_Days
Syntax:
_Date_Substract_Days(anyDateTime1,
nDays)
Purpose: Subtracts a specified number of days (can be decimals) from a given DateTime value.
Example:
_Print_Console(_Date_Time())
Output: 11/11/2023 1:18:35 AM
_Print_Console(_Date_Substract_Days(_Date_Time(),
28.5))
Output: 10/13/2023 13:18:35
Date_Time
Syntax:
_Date_Time()
Purpose: Returns the current date and time.
Example:
_Print_Console(_Date_Time())
Output: 11/11/2023 10:11:01 PM
Date_Time24
Syntax:
_Date_Time24()
Purpose: Returns the current date and time in 24-hour format.
Example:
_Print_Console(_Date_Time24())
Output: 11/11/2023 22:11:01
Date_Time24_UTC
Syntax:
_Date_Time24_UTC()
Purpose: Returns the current date and time in 24-hour format (UTC).
Example:
_Print_Console(_Date_Time24_UTC())
Output: 11/11/2023 22:11:01
Date_Time_UTC
Syntax:
_Date_Time_UTC()
Purpose: Returns the current date and time (UTC).
Example:
_Print_Console(_Date_Time_UTC())
Output: 11/11/2023 10:11:01 PM
Date_UTC
Syntax:
_Date_UTC()
Purpose: Returns the current date in short format (UTC).
Example:
_Print_Console(_Date_UTC())
Output: 11/11/2023
Date_to_JulianDate
Syntax:
_Date_to_JulianDate(anyDateTime)
Purpose: Converts a calendar date to its equivalent Julian Date representation (a double-precision number).
Example:
_Print_Console(_Date_to_JulianDate("11/04/1994
12:34:56 PM"))
Output: 2449661.02426
_Print_Console(_JulianDate_to_Date(2449661.02426))
Output: 11/04/1994 12:34:56
Day
Syntax:
_Day(anyDateTime)
Purpose: Extracts the day (as a number) from a given date or DateTime value.
Example:
_Print_Console(_Day(_Date()))
Output: 11
_Print_Console(_Day("01/15/1994"))
Output: 15
Global_Timer
Syntax:
_Global_Timer()
Purpose: Returns the current time in seconds since January 1st, 1970 (Unix Epoch time).
Hour
Syntax:
_Hour(anyDateTime)
Purpose: Extracts the hour (as a number) from a date, time, or DateTime value.
Example:
_Print_Console(_Hour("12:20:00"))
Output: 0
_Print_Console(_Hour("22:20:00"))
Output: 22
_Print_Console(_Hour("11:20:00
PM"))
Output: 23
JulianDate_to_Date
Syntax:
_JulianDate_to_Date(julianDate)
Purpose: Converts a Julian Date (a double-precision number) back into its equivalent calendar date.
Example:
_Print_Console(_Date_to_JulianDate("11/04/1994
12:34:56 PM"))
Output: 2449661.02426
_Print_Console(_JulianDate_to_Date(2449661.02426))
Output: 11/04/1994 12:34:56
Minute
Syntax:
_Minute(anyDateTime)
Purpose: Extracts the minute (as a number) from a date, time, or DateTime value.
Example:
_Print_Console(_Minute(_Date_Time()))
Output: 12 (Example assumes current time)
_Print_Console(_Minute("12:23:40
AM"))
Output: 23
Month
Syntax:
_Month(anyDateTime)
Purpose: Extracts the month (as a number) from a date or DateTime value
Example:
_Print_Console(_Month(_Date()))
Output: 11
_Print_Console(_Month("01/15/1994"))
Output: 1
Month_Name
Syntax:
_Month_Name(anyDate)
Purpose: Returns the full name of the month for a given date or DateTime value.
Example:
_Print_Console(_Month_Name(_Date_Time()))
Output: November (Example assumes current month)
Month_Short_Name
Syntax:
_Month_Short_Name(anyDate)
Purpose: Returns the abbreviated name of the month for a given date or DateTime value.
Example:
_Print_Console(_Month_Short_Name(_Date_Time()))
Output: Nov (Example assumes current month)
PostDate_Add_Days
Syntax:
_PostDate_Add_Days(postdate,
d)
Purpose: Adds days (can be decimals) to a postdate formatted as "yyyymmddhhmmss".
Example:
d
= _Date_Diff(_Date_Time24(), _Date_Time24_UTC())
_Print_Console(_add_days_to_postdate("20200809202115",
d))
Second
Syntax:
_Second(anyDateTime)
Purpose: Extracts the second (as a number) from a date, time, or DateTime value.
Example:
_Print_Console(_Second(_Date_Time()))
Output: 35 (Example assumes current time)
Time
Syntax:
_Time()
Purpose: Returns the current time.
Example:
_Print_Console(_Time())
Output: 11:20:10 PM
Time24
Syntax:
_Time24()
Purpose: Returns the current time in 24-hour format.
Example:
_Print_Console(_Time24())
Output: 23:20:10
Time24_UTC
Syntax:
_Time24_UTC()
Purpose: Returns the current time in 24-hour format (UTC).
Example:
_Print_Console(_Time24_UTC())
Output: 23:20:10
Time_UTC
Syntax:
_Time_UTC()
Purpose: Returns the current time (UTC).
Example:
_Print_Console(_Time_UTC())
Output: 11:20:10 PM
Timer
Syntax:
_Timer()
Purpose: Returns the time in milliseconds since the app was started.
Week_Day
Syntax:
_Week_Day(anyDate)
Purpose: Returns the day of the week (as a number, 0=Sunday, 1=Monday, etc.) for a given date.
Example:
_Print_Console(_Week_Day("11/04/1994"))
Output: 5
Week_Day_Name
Syntax:
_Week_Day_Name(anyDate)
Purpose: Returns the full name of the day of the week for a given date.
Example:
_Print_Console(_Week_Day_Name("11/04/1994"))
Output: Friday
Year
Syntax:
_Year(anyDate)
Purpose: Extracts the year (as a number) from a given date or DateTime value.
Example:
_Print_Console(_Year(_Date()))
Output: 2023
_Print_Console(_Year("01/15/1994"))
Output: 1994