how to get date format of a date field in H5 script

Kirill Kuchumov

Hi,

I have a standard date picker on M3 panel.

I can get value from the field, value = 211217

Is there a way to get date format of the date picker?

Thanks

Kirill

Rene Bottern

Hi Krill,

you can try something like I have done before.

Find the Date Format for the User:
currFormat = userContext['DTFM'];

Then create a Function to convert based on this (something like the below):

  function convToDate(strDate, currFormat) {
var convertedDate;
if (newFormat == "YMD8") {
convertedDate = Date.parse(strDate.substring(4,6) + "/" + strDate.substring(6,8) + "/" + strDate.substring(2,4));
}
if (newFormat == "YMD") {
convertedDate = Date.parse(strDate.substring(2,4) + "/" + strDate.substring(4,6) + "/" + strDate.substring(0,2));
}
if (newFormat == "DMY") {
convertedDate = Date.parse(strDate.substring(2,4) + "/" + strDate.substring(0,2) + "/" + strDate.substring(4,6));
}
if (newFormat == "MDY") {
convertedDate = Date.parse(strDate.substring(0,2) + "/" + strDate.substring(2,4) + "/" + strDate.substring(4,6));
}

return convertedDate;
}