Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Christian Tabligan
  Where is Christian Tabligan?
 Bacolod City, Neg. Occ.
 Philippines
 Christian Tabligan
 To: Anders Altberg
  Where is Anders Altberg?
 Uppsala
 Sweden
 Anders Altberg
 Tags
Subject: RE: Selecting by date
Thread ID: 288634 Message ID: 288886 # Views: 27 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Grids
Date: Saturday, December 25, 2010 9:27:41 AM         
   


> >
> > it's MDY format. :-)
> >
> > Best Regards,
> >
> > CriZ (,")
> >
> > "We are the foxes, we are the runners, we are the dancers, we create the dreams."
>
> The Help only shows
> DATE([nYear, nMonth, nDay])
> but yours might be different ;-)
>
> -A

You are right Anders. ;-)

The reason why It didn't produced errors because of ON ERROR * on my test programs. (lol)

ON ERROR *
SET DATE DMY
?DATE(25, 12, 10) && It must be DATE([nYear, nMonth, nDay]) no matter what date format.
ON ERROR 


Best Regards,

CriZ (,")

"We are the foxes, we are the runners, we are the dancers, we create the dreams."

ENTIRE THREAD

Selecting by date Posted by Rog @ 12/22/2010 8:40:21 PM
RE: Selecting by date Posted by Anders Altberg @ 12/22/2010 8:54:00 PM
RE: Selecting by date Posted by Rog @ 12/22/2010 10:27:39 PM
RE: Selecting by date Posted by Luis Maria Guayan @ 12/22/2010 11:07:58 PM
RE: Selecting by date Posted by Anders Altberg @ 12/23/2010 12:21:04 AM
RE: Selecting by date Posted by Christian Tabligan @ 12/23/2010 9:13:49 AM
RE: Selecting by date Posted by Anders Altberg @ 12/23/2010 2:46:01 PM
RE: Selecting by date Posted by Christian Tabligan @ 12/24/2010 2:58:55 AM
RE: Selecting by date Posted by Anders Altberg @ 12/24/2010 1:37:10 PM
RE: Selecting by date Posted by Christian Tabligan @ 12/25/2010 9:27:41 AM
RE: Selecting by date Posted by Cetin Basoz @ 12/23/2010 10:08:56 AM
RE: Selecting by date Posted by Samir H. @ 12/26/2010 1:27:09 PM
RE: Selecting by date Posted by Cetin Basoz @ 12/26/2010 6:00:24 PM