Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: pat mazuel
  Where is pat mazuel?
 riom
 France
 pat mazuel
 To: Anders Altberg
  Where is Anders Altberg?
 Uppsala
 Sweden
 Anders Altberg
 Tags
Subject: RE: calculating datetime
Thread ID: 249114 Message ID: 249121 # Views: 2 # Ratings: 0
Version: Visual FoxPro 8 Category: Databases, Tables and SQL Server
Date: Monday, December 28, 2009 9:43:11 PM         
   


> > Thanks to both of you.
> >
> > Stehan the error message was "Function argument value, type, or count is invalid (Error 11)",
> > Sorry Yuri that I didn't think to include it.
> >
> > There was one "dateprise" that was empty. As soon as I filled it in all worked correctly.
> > I'm not sure why it was working if I only took the last 15 days, but failed if I took the last 30 days, but it did.
> > But at least now I know what the problem was.
> >
> > Stefan, I can't find any references to a CAST function in VFP ?
> >
> > Pat
> >
> >
> >
>
> CAST() came in VFP9. DTOT() should work as well.
>
> -Anders


Thanks, this application is still in VFP8, my other apps are in VFP9.
So I did check the help file in VFP9, but no cast() . Strange.
I have just now checked a book I bought "what's new in Nine" and I can find cast() there, so thanks for the info

Pat

ENTIRE THREAD

calculating datetime Posted by pat mazuel @ 12/28/2009 6:37:32 PM
RE: calculating datetime Posted by Yuri Rubinov @ 12/28/2009 7:13:10 PM
RE: calculating datetime Posted by Stefan Wuebbe @ 12/28/2009 8:11:37 PM
RE: calculating datetime Posted by pat mazuel @ 12/28/2009 8:31:02 PM
RE: calculating datetime Posted by Anders Altberg @ 12/28/2009 9:33:15 PM
RE: calculating datetime Posted by pat mazuel @ 12/28/2009 9:43:11 PM
RE: calculating datetime Posted by Anders Altberg @ 12/29/2009 12:37:32 AM
RE: calculating datetime Posted by Anders Altberg @ 12/28/2009 9:29:15 PM
RE: calculating datetime Posted by pat mazuel @ 12/28/2009 9:37:34 PM
RE: calculating datetime Posted by M. Akram Bhatti @ 12/29/2009 6:20:20 AM
RE: calculating datetime Posted by tushar @ 12/29/2009 6:40:41 AM
RE: calculating datetime Posted by pat mazuel @ 12/29/2009 7:58:35 AM