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

David ForderDavid Forder Member
edited January 2018 in Questions
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 :(


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 )




 

Comments

  • Louis SkeltonLouis Skelton Member
    edited December 2017
    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.
  • Louis SkeltonLouis Skelton Member
    edited December 2017
    Ooops - just saw that you're using Skuid Platform so the custom field thing I mentioned does not apply.
  • David ForderDavid Forder Member
    edited January 2018
    Thanks Luois.. adding the dateVar declaration worked!

    Appreciate the assist ))
Sign In or Register to comment.