Find Lowest Date From Multi Fields

Answered

Follow

Dhakesh N. Gautam

• July 04, 2015 12:40

Hi

I have an Apps "Documents" and it contain Multi type document Expiry Date. Passport, ID, Licenses, OtherPass etc.
Now i just want to add a calculation field and Get Upcoming Expiry Date from those DateFields.

Thanks in Advance

0

• 

  Rainer Grabowski (FVM)

  • July 04, 2015 13:44

  Hi,

  do you want a calculation like: if expiry date = today show "Expired" ? If so that's not possible. see here: https://help.podio.com/hc/communities/public/questions/202577457-Determine-if-a-deliverable-is-overdue-and-display-Overdue-if-it-is-?_ga=1.164409081.716129646.1431329936

  Or are you asking for another use case?

  Rainer

  0

  Comment actions Permalink
• 

  Dhakesh N. Gautam

  • July 04, 2015 14:41

  Mr. Rainer;

  I just want to Get Min.Date Between those 4 Fields

  0

  Comment actions Permalink
• 

  Rainer Grabowski (FVM)

  • July 06, 2015 09:07

  Ah ok, didn't get it that these are all date fields. sorry.
  I'm sure there would be a more elegant way, but this works:

   dat1 = moment(@date 1).format("YYYY-MM-DD");
   dat2 = moment(@date 2).format("YYYY-MM-DD")
   dat3 = moment(@date 3).format("YYYY-MM-DD");
   dat4 = moment(@date 4).format("YYYY-MM-DD");
  
  var arr = [dat1,dat2,dat3,dat4]
  var arr1 = arr.sort().join().split(",")
  moment(arr1[0]).toDate()
  

  Instead of @date 1 etc. enter your date fields. The result is a date in date format which can be shown in a calendar. This formula is for calculating the dates in the same item.

  Rainer
  rg@delos-consutling.com

  1

  Comment actions Permalink
• 

  Dhakesh N. Gautam

  • July 06, 2015 09:31

  Thanks Mr. Rainer

  It works Perfectly but I wish if All date fields are Blank than its Should be Blank instead of 01/01/1970

  0

  Comment actions Permalink
• 

  Rainer Grabowski (FVM)

  • July 06, 2015 12:14

  Then you have to tell the calculation: if all date fields blank show nothing.
  Change last line:

  arr.length == 0 ? null : moment(arr1[0]).toDate()
  

  If null doesn't work try "".
  Rainer

  0

  Comment actions Permalink
• 

  Dhakesh N. Gautam

  • July 06, 2015 12:36

  Hi

  Something Is wrong I tried "" Instead of null but Result is Same as earlier.

  0

  Comment actions Permalink
• 

  Rainer Grabowski (FVM)

  • July 06, 2015 13:58

  Sorry,my mistake.

  Change last line to

  arr1.join().replace(/[Invalid date,]/g, "") == "" ? null : moment(arr1[0]).toDate()
  

  Rainer

  1

  Comment actions Permalink
• 

  Dhakesh N. Gautam

  • July 06, 2015 14:35

  Thank you Mr. Rainer it works.

  0

  Comment actions Permalink
• 

  Dan Stroehlein

  • June 12, 2018 22:55

  How do you get the max date instead of the min date?

  0

  Comment actions Permalink
• 

  Rainer Grabowski

  • June 13, 2018 11:16
  • Edited

  Hi Dan,

  just add .reverse() after .sort() to get the "youngest" (= max) date 

  dat1 = moment(@Date 1).format("YYYY-MM-DD");
  dat2 = moment(@Date 2).format("YYYY-MM-DD");
  dat3 = moment(@Date 3).format("YYYY-MM-DD");
  var arr = [dat1,dat2,dat3].filter(function (i) { return i != "Invalid date"; }).sort().reverse();
  arr.length == 0 ? "" : moment(arr[0]).toDate() 
  
  

  The filter function removes date fields which are empty.
  Rainer

  0

  Comment actions Permalink
• 

  Dan Stroehlein

  • June 13, 2018 18:55

  Thank Rainer!

  0

  Comment actions Permalink

Please sign in to leave a comment.