TN 1290 How to Parse j5 Date / Time in the IndustraForm Designer

Description

This article from InSource shows how to parse j5 date / time in the IndustraForm Designer

• Author: Ron Tanner
• Published: 9/27/2022
• Applies to: j5

Details

How to parse j5 date / time in the IndustraForm Designer

The Date/Time element in the IndustraForms allows the end user to pick date/time.

To display this information in different formats you must create a formula to parse out the date/time because the actual value is a serialization of the date/time in j5.

Create a new IndustraForm:

Create 4 elements:

Element name: LabelDateTime
Type: Date / Time:

Element name: TimeCreated
Type: Date & Time
Default Value: =Now()

Element name: LabelParseDateTime
Type: Label

Element name: ParsedDateTime
Type: Text
Value: =CONCATENATE(DAY(TimeCreated),"/",MONTH(TimeCreated),"/",YEAR(TimeCreated),"-",HOUR(TimeCreated),":",MINUTE(TimeCreated))

The formula uses the value of the element named “TimeCreated” as a parameter.
The formula uses the CONCATENATE function along with the DAY/MONTH/YEAR to build the format needed to display the date. Any number of combinations can be used based on the format requirements for date/