Is there a way in Get Form Elements Items from Features, in the Label Input to convert the date field (1590087600000) into "L" format directly.

Jenny Oh

3. November 2020 17:46

 My Label Input is set to **{ID}-{InspectorName}-{InspectionDate}**. It appears in the autocomplete as 899-JOHN SMITH-1590087600000. I want it to appear as 899-JOHN SMITH-05/21/2020 . I tried formatdate and set it to the same attribute but the string value is not accepted since the attribute is of date type. It would be nice if the date fields in the feature attributes are formatted.

 

0

• 

  Hilary Barr

  2. Februar 2021 16:19

  @Oh, Jenny?  Did you ever figure this one out?

  0
• 

  Jenny Oh

  2. Februar 2021 21:58

  I did not use query layer activity but use a server workflow which does a "Run Sql Query" to format the dates. Set the output from the server workflow in "Get Form Elements from Collection" activity. Set the Label to =" **{InspectorName}** \n\n Inspection Date: *{InspectionDate}*\n\n Inspection Type: *{InspectionType}*\n\n Ramp Type: *{RampType}*\n\n " Note that the field names are different for you. Fieldnames are in the curly parentheses{} {InspectorName} is a field which is returned from my Server workflow output. Try a simple query first. I wanted to use Query Layer but it is not possible yet. Hope this helps. Good luck!

  0

Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.