Hello, I'm trying to format variable values in a specific format:
In a script, I have my variable Sortant.CHAMPS_LIBRES_1
in the format string DD/MM/YYYY
, and my variable Sortant.CHAMPS_LIBRES_2
in the format string HH:MM
. I would like to have the following result in the variable RDV_FINAL
: YYYY-MM-DDTHH:MM:SS+0200
.
I tried this, but it doesn't work:
format(date({{Sortant.CHAMPS_LIBRES_1}}, 'DD/MM/YYYY'), 'YYYY-MM-DDTHH:mm:ssZ') + {{Sortant.CHAMPS_LIBRES_2}}
Do you have any idea how to do this? Thank you.