Number of days between 2 dates
John Dixon
dixonja at hotmail.co.uk
Wed Apr 16 12:47:58 EDT 2014
This seems to work...
on mouseUp
put the short date into dayNow
convert dayNow to seconds
put dayNow into startCalc
convert dayNow to dateItems
put item 1 of dayNow into theYear
put "01/01/" & theYear into theYearStart
convert theYearStart to seconds
put theYearStart into endCalc
put startCalc - endCalc into tempCalc
put trunc(tempCalc/86400)
end mouseUp
> Date: Wed, 16 Apr 2014 18:45:48 +0200
> From: m.schonewille at economy-x-talk.com
> To: use-livecode at lists.runrev.com
> Subject: Re: Number of days between 2 dates
>
> Hi Jbv,
>
> This subject has been discussed very frequently. You may want to search
> the archives for a solution.
>
> Probably, all will work fine if you take 12:00 instead of 00:00. DST may
> be the culprit.
>
> --
> Best regards,
>
> Mark Schonewille
>
> Economy-x-Talk Consulting and Software Engineering
> Homepage: http://economy-x-talk.com
> Twitter: http://twitter.com/xtalkprogrammer
> KvK: 50277553
>
> Installer Maker for LiveCode:
> http://qery.us/468
>
> Buy my new book "Programming LiveCode for the Real Beginner"
> http://qery.us/3fi
>
> LiveCode on Facebook:
> https://www.facebook.com/groups/runrev/
>
> On 4/16/2014 18:25, jbv at souslelogo.com wrote:
> > Hi list,
> >
> > I need to calculate the number of days between any date and
> > january 1st of the same year.
> > So I tried this :
> > put "1/31/14" && "0:00 AM" into tdate
> > convert tdate to long seconds
> > put "1/1/14" && "0:00 AM" into date0
> > convert date0 to long seconds
> > put (tdate - date0)/86400
> >
> > which seems to work and returns an integer.
> > When I try this as 1st line of my script :
> > put "3/30/14" && "0:00 AM" into tdate
> > it still works (returns 88).
> >
> > And suddenly, the following :
> > put "3/31/14" && "0:00 AM" into tdate
> > returns 88.958333
> >
> > Any idea ?
> >
> > Thanks,
> > jbv
> >
> >
> > _______________________________________________
> > use-livecode mailing list
> > use-livecode at lists.runrev.com
> > Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> > http://lists.runrev.com/mailman/listinfo/use-livecode
> >
>
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
More information about the use-livecode
mailing list