Date Intrinsic Functions (PRIM_LIBI.IDateIntrinsics)
Date intrinsic functions
Ancestors - None

Details

Container for all date intrinsic functions

Methods

Name	Description
Adjust	Increment or decrement the date Result, Adjustment
AsDateTime	Return a date as a datetime Result, Time
AsDayOfWeek	Return the date as a day of the week Result, Format
AsDays	Return the date as the number of days since 01/01/00 Result
AsDisplayString	Convert the variable to a formatted string Result, Format
AsNumber	Return the variable as a number Result, Format
AsString	Return the variable as a string Result
AsValue	Return the variable as a value if SQLNull Result, Default
Day	Return the day portion of the date Result
Difference	Return the difference between 2 dates in days Result, Object
IsNotSqlNull	Test if the variable is not SQLNull Result
IsNull	Test if the variable is a LANSA null Result
IsSqlNull	Test if the variable is SQLNull Result
Max	Returns the latest date Result, Date1, Date2, Date3, Date4, Date5, Date6, Date7, Date8, Date9
Min	Returns the earliest date Result, Date1, Date2, Date3, Date4, Date5, Date6, Date7, Date8, Date9
Month	Return the month portion of the date Result
Now	Return the current date Result
Week	Return the week number Result, StartOfWeek, Format
Year	Return the year portion of the date Result