AppleScript Date calculation

applescripttime

I created this script to do date calculation between a date and today, but for some reason I get a decimal number.

How can I just get the number of date without decimal point ?

Tried to use a roundup formula but that's messy, what the best way to handle this?

set theDateWantedValue to "25/03/2019"

set [dayVal, MonthVal, YearVal] to the words of theDateWantedValue
set the text item delimiters to "/"
##set date_string to {d, ordinal, Y} as text
##set myotherDate to date_string

set dateDelaybetwentheDate to ((date (theDateWantedValue as string)) - (current date)) / days


set myResultDateRound to RoundDecimal(dateDelaybetwentheDate, 1, down)

on RoundDecimal(NumberToRound, DecimalPlace, UpDown)
    set RoundFactor to 10 ^ DecimalPlace
    NumberToRound * RoundFactor
    round result rounding UpDown
    result / RoundFactor
end RoundDecimal

Best Answer

Maybe using a different approach will accomplish what you were looking for?

set someDate to "09/ 09 / 2019"
set theDate to date someDate
set currentDate to (current date)

set secondsBetweenDates to (theDate - currentDate)
set timeInDays to (secondsBetweenDates div days)
set timeInWeeks to (secondsBetweenDates div weeks)
set extraDays to (timeInDays mod timeInWeeks)


display dialog ((timeInWeeks as text) & " Weeks & " & extraDays & " Days Remaining Until " & someDate) ¬
    buttons {"Cancel", "OK"} default button "OK"

Obviously change the value of someDate to whatever you need

Related Solutions

Date calculation in AppleScript. Week numbers and their start date

Thanks to @ryan-m's comment I found a solution. Turns out date(1) is actually really cool. Its ability to do "adjustments" were the answer.

You can tell date to simply "go to" a specific day by using -v. You can then use plus and minus to "adjust" that date in another -v. So for instance:

date -v 1w -v 16y

Will go to the first month of 2016. (Or a date that contains that date)

With an adjustment we can walk through dates:

date -v +1w -v +0d -v 16y
date -v +1w -v +6d -v 16y

This goes to the first week of 2016. The second command goes from the beginning of that first week 6 days ahead. This is the 10th of January 2016. -v +2w would be the second week, and so forth. It's apparent which part can be automated here.

Everything that +'string' at the end does is it formats the date you're at in the way you want it displayed. I use this in my script to make a date-string that AppleScript's date command understands. Please don't confuse the shell command date(1) with the AppleScript date command.

This is the script I ended up with, by the way:

repeat with weekNumber from 1 to 52
    set weekStartShell to (do shell script "date -v +" & weekNumber & "w -v +0d -v 16y +'%d. %m. %Y'")
    set weekStart to date weekStartShell
    set weekEndShell to do shell script "date -v +" & weekNumber & "w -v +6d -v 16y +'%d. %m. %Y'"
    set weekEnd to date (weekEndShell & " 23:59:59")
    set projectName to (("CW" & weekNumber & ": " & weekStartShell & " - " & weekEndShell) as string)

    tell application "OmniFocus"
        tell folder "Day Projects" of default document
            set projectWeek to make new project with properties {name:projectName, defer date:weekStart, due date:weekEnd, singleton action holder:true}

        end tell
    end tell

end repeat

Note that in order to use AppleScript's set var to date "date-string" you have to give it a string in your locale. In Europe the string is 01. 02. 2016 23:59:59. In America this probably is something like 2016/02/01 23:59:59. You need to modify these in the variables in the script. (+'%Y/%m/%d' at the end)

Applescript : String to Date

You can use the NSDataDetector (a cocoa method) for parsing date from a string.

Here's the script (tested on macOS Sierra):

Warning: on a string which contains "digit/digit/year", the script does not work with a string in the "day/month/year" format, the string must be in the "month/day/year" format

use framework "Foundation"
use scripting additions

(* this script works on these formats: 
"Sunday 10th September 2017", "Sunday 10 September 2017", "Sunday 10 September 17", "September 10th, 2017", "September 10th 2017", "September 10 2017"
 "10th September 2017", "10 September 2017", "10 Sep 17"
 also work with the abbreviation ( e.g. Sep instead of September and Sun instead of Sunday) 
 also work with the localized name of (the month and the day)

"09/10/2017", "09.10.2017", "09-10-2017" : month_day_year only,  or "2016/05/22", "2016-05-22", "2016.05.22" : year_month_day only 
( month and days could be one or two digits)
*)

set myString to "Nov 5th, 2005"
set dateString to my stringToDate(myString) --> "05/11/2005"

on stringToDate(thisString) -- 
    tell current application
        -- **  finds all the matches for a date, the result is a NSArray ** 
        set m to its ((NSDataDetector's dataDetectorWithTypes:(its NSTextCheckingTypeDate) |error|:(missing value))'s matchesInString:thisString options:0 range:{0, length of thisString})
        if (count m) > 0 then
            set d to (item 1 of m)'s |date|() -- get the NSDate of the first item 
            set df to its NSDateFormatter's new() -- create a NSDateFormatter 
            df's setDateFormat:"dd/MM/yyyy" -- a specified output format: "day/month/year" (day and month = two digits, year = 4 digits)
            return (df's stringFromDate:d) as text
        end if
    end tell
    return "" -- no match in this string
end stringToDate

Best Answer

Related Solutions

Date calculation in AppleScript. Week numbers and their start date

Applescript : String to Date

Related Question