Question

Formatting date format

0

The below expression displays the date in this particular format-----> 1/18/15 5:30 AM toString(trimToDaysUTC(addDaysUTC(([%EndOfCurrentDay%]),-3))) I want to display it like 18-Jan-2015 How I can do this?

asked 2015-01-21

Md Naqui Qureshi

1 answers

Rom van Arendonk · Accepted Answer · 2015-01-21

The function you are looking for is called formatDateTime(). It takes a date and a string as parameters. The string defines the format of the date, as you can see here.

The answer to you question is: formatDateTime([%EndOfCurrentDay%], 'dd-MMM-yyyy')