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

Can you run the below code and let me know the values you are getting through info messages ?



var nvd= new GlideDateTime(current.u_verification_date); 

gs.addInfoMessage("Verification Date"+nvd);

nvd.addYears(1);

gs.addInfoMessage("After adding"+nvd);

Hi Ravi,
 
PFB output:
 
Info Message
Verification Date2018-10-03 06:11:23
Info Message
After adding2019-10-03 06:11:23
 
Thanks
Vass

So the results showing it added 1 year?

vass2
Mega Expert

Yes, it was adding earlier also, my concern is how to change date format to dd-mm-yyyy hh:mm:ss

Thanks

Srinivas.

For converting,check below code:

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