Skip to main content
InSource Solutions

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:
clipboard_ef5c910eb455caf976ae13e89ed119b02.png

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

Element name: LabelParseDateTime
Type: Label
clipboard_ef090b9aad71a5754c8e2bda5f7cf6f4e.png

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

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/time.

  • Was this article helpful?