Hello to every one, i'm a new user in this wonderful app, but in my trying to understand the use of this app i have had troubles customizing my date of register from survey123 to a row in table excel.
I have written this piece of function in my box
Solved! Go to Solution.
Hi @jalastrag28 :
Firstly, let me explain why you encountered this problem.
The point is the value of
concat(addseconds('1970-1-1', Div(triggerBody()?['feature']?['attributes']?['FECHA'],1000) , 'dd/MM/yyyy'),' ',triggerBody()?['feature']?['attributes']?['HORA'])
do not match ISO 8601 format.
The correct ISO 8601format is
yyyy-MM-ddThh:mm
Finally, please try this formula:
formatDateTime(concat(addseconds('1970-1-1', Div(triggerBody()?['feature']?['attributes']?['FECHA'],1000) , 'yyyy-MM-dd'),'T',triggerBody()?['feature']?['attributes']?['HORA']) , 'dd/MM/yyyy hh:mm')
Best Regards,
Bof
Hi @jalastrag28 :
Firstly, let me explain why you encountered this problem.
The point is the value of
concat(addseconds('1970-1-1', Div(triggerBody()?['feature']?['attributes']?['FECHA'],1000) , 'dd/MM/yyyy'),' ',triggerBody()?['feature']?['attributes']?['HORA'])
do not match ISO 8601 format.
The correct ISO 8601format is
yyyy-MM-ddThh:mm
Finally, please try this formula:
formatDateTime(concat(addseconds('1970-1-1', Div(triggerBody()?['feature']?['attributes']?['FECHA'],1000) , 'yyyy-MM-dd'),'T',triggerBody()?['feature']?['attributes']?['HORA']) , 'dd/MM/yyyy hh:mm')
Best Regards,
Bof
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
User | Count |
---|---|
80 | |
56 | |
55 | |
43 | |
39 |
User | Count |
---|---|
84 | |
81 | |
76 | |
63 | |
42 |