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

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

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

Samaksh Wani
Giga Sage
Giga Sage

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]

}

 

Samaksh Wani
Giga Sage
Giga Sage

Similar for March 

Samaksh Wani
Giga Sage
Giga Sage

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 @Samaksh Wani, i think that there is need to apply some changes on 

DevYadav_0-1690293396044.png

because everytime, else part is run