Einddatum WA automatisch aanpassen op basis van datumveld in formulier

Hey there,

This freemarker part will retrieve value of datetime field inputted on a SSP formular.

<#setting locale="da_DK">
<#setting time_zone="Europe/Copenhagen">
<#assign startDate = (_progresstrail["requests"]?first["richtext"])?keep_after("📅<br/>- ")?keep_before("<br/>")?datetime("d. MMMM yyyy HH:mm")>

<#setting time_zone="UTC">
[
 {
  "op": "replace",
  "path": "/optionalFields2/date1",
  "value": "${startDate}"
 }
]

The assigned variable startDate will contain the datetime value from the request field.

I have made so it looks for the 📅 (calendar emoji) which should be added at the end of the field question.

Example: Please set starting date and time📅

- 

Remember to set the datetime format, so it matches what is displayed in request field: ?datetime("d. MMMM yyyy HH:mm") 
Source: SimpleDateFormat (Java Platform SE 7 ) 

You also need to set the locale and time_zone, so it matches the request fields datetime value, you want to grab.
OBS. do NOT alter this time_zone setting <#setting time_zone="UTC">

Hi ​@Y.Akyuz ,

You can also add some calculations as addition to the post of ​@Jeppe Gents . Keep in mind that the additions you do will be in miliseconds. Example:

<#setting time_zone="Europe/Amsterdam">
[
  {
    "op": "replace",
    "path": "/plannedFinalDate",
    "value": "${(
      ((_responses.getChangeInfo.body.optionalFields1.date1?datetime("yyyy-MM-dd'T'HH:mm:sss"))?long + 8 * 86400000)
      > .now?long
      )?then(
        ((_responses.getChangeInfo.body.optionalFields1.date1?datetime("yyyy-MM-dd'T'HH:mm:sss"))?long + 8 * 86400000)?number_to_datetime,
        .now
      )}"
  }
]

In this example, the date entered in the form in the optional fields is calculated with 8 * 1 day in miliseconds.