Formatting a date field that is conditionally displayed

[NaydoJ]

I am having trouble formatting and printing a date field in an e-mail.

The date field in question only needs to be entered and displayed on the e-mail if a date has been entered, and I want the date formatted into dd-MM-yyyy instead of the default yyyy-mm-dd format

I have tried the following expression, but I keep getting an error saying that the expression is invalid:

if(empty(triggerBody()?['EndDate']),null,formatedatetime(triggerBody()?['EndDate'],’dd-MM-yyyy’))

However the following expression (without the date formatting) works:

if(empty(triggerBody()?['EndDate']),null,triggerBody()?['EndDate'])

[efialttes]

Hi!

There is a typo in the WDL function name

formatedatetime ->formatdatetime

If the problem persists, please share triggerBody()?['EndDate'] contant that make the expression fail

Hope this saves your day

[SanchezCSG]

Good catch!

@NaydoJ 

If not, try with  formatDateTime(item()?['EndDate'], 'dd-MM-yyyy')