Date Formatted ddMMyyyy

raymantle · March 31, 2020, 8:54pm

Hi,

When I format a date to dd-MM-yyyy I get 31-03-2020 in my text input.
<input name="TIMESTAMP" dmx-bind:value="var1.datetime.formatDate("dd-MM-yyyy")">

However, when I try ddMMyyy without the hyphen I just get ddMMyyyy entered.
<input name="TIMESTAMP" dmx-bind:value="var1.datetime.formatDate("ddMMyyyy")">

Is this a limitation of the date format function or am I doing in incorrectly?

Thanks,
Ray.

Teodor · March 31, 2020, 8:58pm

Hi Ray,
Is it working with spaces, like dd MM yyyy?

Also, are there any errors in the browser console when you use ddMMyyy?

raymantle · March 31, 2020, 9:01pm

Hi @Teodor, yes it works with spaces. I have just checked and no errors when formatted ddMMyyyy.

Teodor · March 31, 2020, 9:05pm

Ok, thanks - we’re going to check this

raymantle · March 31, 2020, 9:06pm

OK thanks.

Trying to do integration with Global Payments(Realex) and they require a timestamp formatted ddmmyyyyhhmmss.

Thanks,
Ray.

patrick · March 31, 2020, 9:24pm

Hi Ray,

Did a bit of testing and it indeed didn’t work with ddMMyyyy. So I directly checked the formatter and fixed it, here is the updated version. Now you can use ddMMyyyyHHmmss which should be what you require.

dmxFormatter.zip (7.6 KB)

raymantle · March 31, 2020, 9:37pm

I have updated Wappler with the updated dmxFormatter.js and can now confirm getting format as required.

Thanks,
Ray.