Help with date format 2016-10-07

[RevDevelopment]

Hello,

I am trying to create a string like this: 2016-09-07+2016-10-07

And the first date string is 30 days before the second date string.

The date needs to be in this format: 2016-10-07

I can't seem to find a way to get it into this format after using dateitems to perform the calculation for the 30 days prior date.

Any ideas?

Thanks!

[Klaus]

Hi RevDev,

1. convert the dateitems back to (system? english?) DATE after your calculation.
2. set the ITEMDELIMITER to SLASH -> /
3. re-create your data to new date format using the three items of the converted date and
4. add leading zeros where neccessary.

Get the picture?


Best

Klaus

[jacque]

Here's a start:

Code: Select all

function convertDate pDate
  convert pDate to dateitems
  set the numberformat to "00"
  repeat with x = 1 to 3
    put item x of pDate + 0 & "-" after tNewDate
  end repeat
  return char 1 to -2 of tNewDate
end convertDate

[RevDevelopment]

Thank you so much for the help! I really appreciate it...

Now I'm off to see if I can get this working.

[MaxV]

Debrill libdate library is out there for you: https://github.com/derbrill/libdate