HomeUsing LincDoc 3.1+DANG Rule WizardAbout Function Formatting

10.11. About Function Formatting

Certain functions have specific formatting rules that must be followed.

About Date/Date Time Functions Formatting

When working with date and datetime functions, you need to make sure your date formats and time formats are valid. Date functions use only date formatting, while datetime functions use both date and time formatting. Using a non-valid format can cause unexpected results.

Example: When using the DateToString function, if the first argument is set to DateCurrent (as shown below), you have the ability to set a format (the second argument, highlighted below) that the date will use when it is displayed.

If you use theĀ MM/dd/yyyy format, the date will be returned similar to the following: 07/01/2013. At the same time, if you use the MMMM d, yyyy format, the date returned would be similar to the following: July 1, 2013.

For complete information on supported date and time formats, click here.

This page was: Helpful | Not Helpful