Calculation between variable date and fixed date

Follow

Martyn Kemp

• November 09, 2022 14:03

Hello, I'm hoping someone may help.

I'm trying to work out the calculation for the number of day between a variable (user entered) date and a fixed date in time.

ie: the number of days between todays date (which obviously changes each day) and 21/04/2016. This second date is static. It never changes.

Regards,

Marty

2

• 

  Martyn Kemp

  • November 10, 2022 14:17

  This was my best guess so far, but it is resulting in 30 days too many.

   

  day = moment(@Date Used for Claim Form).format('YYYY, MM, DD')

  var Date1 = new Date (day);

  var Date2 = new Date (2016, 21, 04);

  var Days = Math.floor((Date2.getTime() - Date1.getTime())/(1000*3600*24));

  Days

  0

  Comment actions Permalink
• 

  Martyn Kemp

  • November 17, 2022 22:16

  Is anyone able to offer up any other guesses?

  0

  Comment actions Permalink
• 

  Rainer Grabowski

  • November 21, 2022 21:59

  Hi Martyn,

  var Date1 = moment(@Date Used for Claim Form);
  var Date2 = moment("2016-04-21","YYYY-MM-DD");
  Date2.diff(Date1,"days")

   

  0

  Comment actions Permalink
• 

  Martyn Kemp

  • November 22, 2022 16:47

  Thank you so much Rainer!

  0

  Comment actions Permalink

Please sign in to leave a comment.