Date Intrinsic Functions (PRIM_LIBI.IDateIntrinsics)
Date intrinsic functions
Ancestors - None
Container for all date intrinsic functions
| 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 |
Febuary 18 V14SP2