Apply Date Formatting

DevYadav
Tera Contributor

Hi All,

I want to apply date Formatting such that if it 1 then it should be "1st", 2 for "2nd ", 3 for "3rd" and remaining all for "4th or 5th"

i am using this code,

function onChange(control, oldValue, newValue, isLoading, isTemplate) {

if (isLoading || newValue === '') {

return;

}

var months=["jan","feb","march","april","may","june","july","sep","october","november","december"];

newValue= newValue.split("-",[3]);

var month=newValue[1];

var name=(months[month-1]);

var date2= newValue[0]+"th-"+name+"-"+newValue[2];

g_form.setValue('u_date2',date2);

Thanks 

 

2 ACCEPTED SOLUTIONS

Not applicable

Hello @DevYadav 

 

I got you, your date format is some what different, no worries :-

 

 

 

function onChange(control, oldValue, newValue, isLoading, isTemplate) {
if (isLoading || newValue === '') {
return;
}

var months=["jan","feb","march","april","may","june","july","sep","october","november","december"];
newValue= newValue.split("-",[3]);
var month=newValue[1];
var name=(months[month-1]);
var dateM = newValue[2].split("");
var date2;
if((dateM[0]==0 || dateM[0]==2) && (dateM[1]==1)) {
   date2= newValue[0]+"-"+name+"-"+newValue[2]+"st";
}
else if((dateM[0]==0 || dateM[0]==2)&& (dateM[1]==2) ){
   date2= newValue[0]+"-"+name+"-"+newValue[2]+"nd";
}
else if((dateM[0]==0 || dateM[0]==2) && (dateM[1]==3) ){
   date2= newValue[0]+"-"+name+"-"+newValue[2]+"rd";
}
else{
 date2= newValue[0]+"-"+name+"-"+newValue[2]+"th";
}
g_form.setValue('u_date2',date2);
}

 

 

 

This will Definitely Works, Plz try it.

 

 

Plz Mark my Solution as Accept and Give me thumbs up, if you find it Helpful.

 

Regards,

Samaksh

 

 

View solution in original post

Not applicable

Hello @DevYadav 

 

Use this script for your requirement :-

 

 

function onChange(control, oldValue, newValue, isLoading, isTemplate) {
if (isLoading || newValue === '') {
return;
}

var months=["jan","feb","march","april","may","june","july","sep","october","november","december"];
newValue= newValue.split("-",[3]);
var month=newValue[1];
var name=(months[month-1]);
var dateM = newValue[2].split("");
var date2;
if((dateM[0]==0 || dateM[0]==2||dateM[0]==3) && (dateM[1]==1)) {
   date2= newValue[0]+"-"+name+"-"+newValue[2]+"st";
}
else if((dateM[0]==0 || dateM[0]==2)&& (dateM[1]==2) ){
   date2= newValue[0]+"-"+name+"-"+newValue[2]+"nd";
}
else if((dateM[0]==0 || dateM[0]==2) && (dateM[1]==3) ){
   date2= newValue[0]+"-"+name+"-"+newValue[2]+"rd";
}
else{
 date2= newValue[0]+"-"+name+"-"+newValue[2]+"th";
}
g_form.setValue('u_date2',date2);
}

 

 

 

Plz Mark my Solution as Accept and Give me thumbs up, if you find it Helpful.

 

Regards,

Samaksh

View solution in original post

13 REPLIES 13

Not applicable

Hello @DevYadav 

 

Use this line in script after var name line

 

var date2;

 

if(name=="jan"){

date2= newValue[0]+"st-"+name+"-"+newValue[2];

}

if(name=="feb"){

date2= newValue[0]+"nd-"+name+"-"+newValue[2]

}

 

Not applicable

Similar for March 

Not applicable

Hello @DevYadav

 

 

function onChange(control, oldValue, newValue, isLoading, isTemplate) {
if (isLoading || newValue === '') {
return;
}

var months=["jan","feb","march","april","may","june","july","sep","october","november","december"];
newValue= newValue.split("-",[3]);
var month=newValue[1];
var name=(months[month-1]);
var dateM = newValue[0].split(""); var date2; if((dateM[0]==0) || (dateM[0]==2) && (dateM[1]==1) ){ date2= newValue[0]+"st"+"-"+name+"-"+newValue[2]; } else if((dateM[0]==0) || (dateM[0]==2) && (dateM[1]==2) ){ date2= newValue[0]+"nd"+"-"+name+"-"+newValue[2]; } else if((dateM[0]==0) || (dateM[0]==2) && (dateM[1]==3) ){ date2= newValue[0]+"rd"+"-"+name+"-"+newValue[2]; } else{ date2= newValue[0]+"th"+"-"+name+"-"+newValue[2]; } g_form.setValue('u_date2',date2); }

 

 

I have tried on my pdi, it is working fine.

 

Plz Mark my Solution as Accept and Give me thumbs up, if you find it Helpful.

 

Regards,

Samaksh

Hi @Community Alums, i think that there is need to apply some changes on 

DevYadav_0-1690293396044.png

because everytime, else part is run