adding 1 year to a date field is showing wrong value.

vass2 · ‎10-03-2018

Hi All,

Here i am trying to add 1 year and fetch result into u_next_verification_date. when i execute in the message it shows correct , but in the field value showing wrong.

Any help is highly appreciated.

Vass

When i update the record it is showing the correct date values in the message below.

But when i open the record and check the field value it showing wrong. (Highlighted field).

Also i wish the date value should be the blue rounded one hours/minutes/seconds.

SaiRaviKiran Ak · ‎10-08-2018

Try Below Code,Its working fine

var gr = new GlideDateTime();
var gr1=gs.yearsAgo(-1);
var date= gr1.split(' ')[0];
var time=gr1.split(' ')[1];
var gd = new GlideDate();
gd.setValue(date);
date=gd.getByFormat('dd/MM/yyyy');
gr1=date+' '+time; //gr1 is your converted format
gs.addInfoMessage(gr1);

current.u_next_verification_date =gr1;

current.update();

View solution in original post

Archana Reddy2 · ‎10-03-2018

Try inserting the below at Line9 of your code.

var dt =new GlideDateTime(nvd).getDate().getByFormat("MM-dd-yyyy"); //Change as required
var ti = new GlideDateTime().getTime();
gs.info(dt+'---'+ti);
current.u_next_verification_date = dt+' '+ti;

SaiRaviKiran Ak · ‎10-03-2018

Hi,

Try below code:

var nvd= new GlideDateTime(current.u_verification_date); 
nvd.addYears(1);

Thanks,
Ravi

vass2 · ‎10-03-2018

No Luck Ravi. I am getting the same YYYY-MM-DD HH:MM:SS format.

I need some code to change the format to DD-MM-YYYY HH:MM:SS

Thanks

Vass

SaiRaviKiran Ak · ‎10-03-2018

Try below syntax to convert :

nvd.getByFormat('dd/MM/yyyy');

vass2 · ‎10-03-2018

No change Ravi, getByFormat is not showing up in the dot walking when type nvd followed by .

we are in Kingstone version, not sure if it is supported here.

Regards,

Vass