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.
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.
-
@Oh, Jenny? Did you ever figure this one out?
0 -
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
Du måste logga in om du vill lämna en kommentar.
Kommentarer
2 kommentarer