Number of days between 2 dates
dixonja at hotmail.co.uk
Wed Apr 16 18:47:58 CEST 2014
This seems to work...
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
> 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:
> Buy my new book "Programming LiveCode for the Real Beginner"
> LiveCode on Facebook:
> 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:
More information about the use-livecode