Die voraussichtliche Lieferung erfolgt am
{{ Vorgang.EigeneFelder.1__Lieferzeit.Lieferdatum_AM__AB | FormatDate: 'dddd "den" dd.MM.yyyy', 'de-DE'}} zwischen \
{% capture query %}
DECLARE @time AS VARCHAR(20)
DECLARE @hour AS INT
DECLARE @minute AS INT
SET @time = '{{ Vorgang.EigeneFelder.Cat_Abgleich.Ankunft-beim-Kunden }}'
SET @hour = 0
SET @minute = -10
SELECT CAST(DATEADD(HOUR, @hour, DATEADD(MINUTE, @minute, @time)) AS TIME)
{% endcapture -%}\
{% assign result = query | DirectQueryScalar %}\
{{ result | Date: 'HH:mm'}}\
und \
{% capture query %}
DECLARE @time AS VARCHAR(20)
DECLARE @hour AS INT
DECLARE @minute AS INT
SET @time = '{{ Vorgang.EigeneFelder.Cat_Abgleich.Abfahrt-beim-Kunden }}'
SET @hour = 1
SET @minute = 30
SELECT CAST(DATEADD(HOUR, @hour, DATEADD(MINUTE, @minute, @time)) AS TIME)
{% endcapture -%}\
{% assign result = query | DirectQueryScalar %}\
{{ result | Date: 'HH:mm'}} Uhr