Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Cetin Basoz
  Where is Cetin Basoz?
 Izmir
 Turkey
 Cetin Basoz
 To: venkataramesh cheruvu
  Where is venkataramesh cheruvu?
 hyderabad
 India
 venkataramesh cheruvu
 Tags
Subject: RE: How to get the difference between the d
Thread ID: 155145 Message ID: 155199 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 Category: Other
Date: Thursday, December 27, 2007 2:47:59 PM         
   


> Hi,
> You must be using a command like ?(2007-11-01)-(2007-10-21)
> instead try command like ?ctod('2007/11/01')-ctod('2007/10/21') with date set to 'Japan'
> and strictdate set to 0.
>
> C.V.Ramesh


Good math to find out 19:) I didn't think of it since he was saying difference between two dates and not numbers.

?(2007-11-01)-(2007-10-21)


and if VFP's date identifiers were used:

?{^2007-11-01}-{^2007-10-21}


PS: Why one needs so much fuss to specify a correct date. I don't understand why many users are sorting out to ctod() which has dependancy on current date settings (well there is a variation which doesn't with ctod() but still unnecessary conversion).

? {^2007/10/21}
? date(2007,10,21)

both mean Oct 21, 2007 regardless of date settings.


Cetin Basoz

ENTIRE THREAD

How to get the difference between the d Posted by soumya g @ 12/26/2007 7:31:43 AM
RE: How to get the difference between the d Posted by tushar @ 12/26/2007 8:42:07 AM
RE: How to get the difference between the d Posted by venkataramesh cheruvu @ 12/27/2007 1:27:53 PM
RE: How to get the difference between the d Posted by Cetin Basoz @ 12/27/2007 2:47:59 PM
RE: How to get the difference between the d Posted by venkataramesh cheruvu @ 12/28/2007 1:06:12 PM
RE: How to get the difference between the d Posted by Jojo Sabino @ 12/26/2007 9:04:28 AM
RE: How to get the difference between the d Posted by Prasant T @ 12/26/2007 2:14:21 PM
RE: How to get the difference between the d Posted by Ken Murphy @ 12/26/2007 3:41:30 PM
RE: How to get the difference between the d Posted by Cetin Basoz @ 12/26/2007 5:32:19 PM