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

vass2
Mega Expert

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

find_real_file.png

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

find_real_file.png

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. 

find_real_file.png

 

1 ACCEPTED SOLUTION

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

40 REPLIES 40

If it is after update business rule then add current.update() at the end of the code.

vass2
Mega Expert

Thanks for the Reply Manjusha

-Vass

Archana Reddy2
Tera Guru

Hi Vass,

Did you try with what I've suggested ever?

vass2
Mega Expert

Ravi and Archana,

Both of your codes are working . Really thank a lot for your help

but finally one last thing 03-10-2019 00:00:00 time is showing zero

Which i am still working on

 

Can i set both marked as correct?

 

Regards,
Srinivas.

 

From below code you can see proper time values also:

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;

gs.print(gr1);

 

Can you mark my above answer as Correct if it solves your issue?