Javascript for adding days to a date field on Skuid Platform?

Hi all,

I have struggled with this for a while but it is now urgent. My javascript is not anywhere near good.

I have a 

Model - called Dates
Field 1 : {{Date}}
Field 2 : {{Days}}
Field 3 : {{NewDate}}

I would like to get a snippet that runs to add Days to Date and insert NewDate

I tried this… but wrong :frowning:


var params = arguments[0],   $ = skuid.$;
var model = skuid.$M(‘Dates’);
var row = model.getFirstRow();
var dateVar = row.Date;
var daystoadd = row.Days;

dateVar.setDate(dateVar.getDate() + daystoadd);

model.updateRow(row,{NewDate : dateVar});



Can anyone see where I have screwed up )




 

Yo!

A couple of things here - I think you need to create a javascript date object - so change your dateVar declaration to this:

var dateVar = new Date(row.Date);


Then you can do stuff to it. I sometimes use the moment.js library for date manipulation.

Also, make sure you’re not meaning to reference custom fields that would instead need a ‘__c’ after the field name.

Ooops - just saw that you’re using Skuid Platform so the custom field thing I mentioned does not apply.

Thanks Luois… adding the dateVar declaration worked!

Appreciate the assist ))