How to formate datetime from this 2023-11-03 22:51:34 to this 20231103-225134.

[Ajay Singh2]

Can anyone explain how to use datetime in from this 2023-11-03 22:51:34 to this 20231103-225134.formate on onchange client script.

[Samaksh Wani · Accepted solution]

Hello @Ajay Singh2 

It seems you have already brought the datetime

Just use the below code :-

var gdt = g_user_date_time_format;
var dateTime = gdt.split(' ');
var date=dateTime[0].split('-');
var time=dateTime[1].split(':');
var res1= date[0]+date[1]+date[2];
var res2= time[0]+time[1]+time[2];
var res=res1 +'-' +res2;
alert(res);

[-O-]

Where is 2023-11-03 22:51:34 coming from?

I mean running

var dateIn = getDateFromFormat('2023-11-03 22:51:34', 'yyyy-MM-dd HH:mm:ss');
var dateOut = new Date(dateIn);
alert(formatDate(dateOut, 'yyyyMMdd-HHmmss'));

In the browser's console (or a Client Script) will get you an alert showing

20231103-225134

But I'm assuming you need a solution that accepts dynamic input.

[Ajay Singh2]

yes i need a dynamic solution.

[Samaksh Wani]

Hello @Ajay Singh2 

var gdt = g_form.getValue('datetimefieldname')
var dateTime = gdt.split(' ');
var date=dateTime[0].split('-');
var time=dateTime[1].split(':');
var res1= date[0]+date[1]+date[2];
var res2= time[0]+time[1]+time[2];
var res=res1 +'-' +res2;
gs.info(res);

Plz mark my solution as Accept, If you find it helpful.

Regards,

Samaksh

[-O-]

So answer the question: where is 2023-11-03 22:51:34 coming from?