Difference between revisions of "AsDate"

Revision as of 14:50, 10 April 2019

Converts a value into a date using the format specified after the argument.

Example One

Convert a fixed value. Databox CompanyData.Expressions.Date holds the value 15-10-2016 and using Examples.Date.AsDate in the message Expressions.EXPDATE it is converted into the format "ddd dd MMM yyyy"

Setup

The fixed value to be converted.

This is the expression to convert it to a different format. Using the correct formats shown on the Date Expressions page, you can convert this date into almost limitless formats.

The message applies the expression and displays it as seen below.

Example Two

Convert a user entered date. This example follows the same format as the first but using a date entered by the user rather than a fixed value.

Example Three

Setup