Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Borislav Borissov
  Where is Borislav Borissov?
 Sofia
 Bulgaria
 Borislav Borissov
 To: Zia Mughal
  Where is Zia Mughal?
 Rawalpindi
 Pakistan
 Zia Mughal
 Tags
Subject: RE: how to ?
Thread ID: 395462 Message ID: 395468 # Views: 41 # Ratings: 2
Version: Visual FoxPro 9 SP2 Category: Forms
Date: Wednesday, January 15, 2014 9:15:58 AM         
   


> > Hi experts
> >
> > i have 2 dates at form suppose date(2014,07,01) and date(2014,07,31)
> >
> > i have to append them in a table like:
> > date
> > 01/07/2014
> > 02/07/2014
> > 03/07/2014
> > 04/07/2014
> >
> > to ......
> >
> > 31/07/2014
> > do i code it like this :
> >
> >
Select newbook
> > Public ldM1, ldm2
> > ldM1 = date(2014,07,01) 
> > ldM2 = date(2014,07,31) 
> > ldm3 = ldm1
> > scan
> >  if ldm3 < ldm2
> >   Append Blank
> >   Replace Date With ldM3
> >   ldM3 = ldM1 +1
> >  ENDIF 	
> > endscan  
> > 

> > guide me a comprihansive way
>
> your input format is different from database format as u said.
> you should change date format before replace in database
> with function dmy(ldm3)
> e.g Replace date with dmy(ldm3)
>
> Zia Mughal
> Pcland Software Pakistan
> http://www.pcland.com.pk

DB format is DATE no matter how is your SET DATE set.



-----------------
Borislav Borissov

Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.

ENTIRE THREAD

how to ? Posted by Shaheryar Rashed @ 1/15/2014 8:45:08 AM
RE: how to ? Posted by Tore Bleken @ 1/15/2014 9:06:48 AM
RE: how to ? Posted by Shaheryar Rashed @ 1/15/2014 9:25:47 AM
RE: how to ? Posted by Tore Bleken @ 1/15/2014 9:29:34 AM
RE: how to ? Posted by Zia Mughal @ 1/15/2014 10:52:01 AM
RE: how to ? Posted by Tore Bleken @ 1/15/2014 10:59:01 AM
RE: how to ? Posted by Zia Mughal @ 1/15/2014 9:11:57 AM
RE: how to ? Posted by Borislav Borissov @ 1/15/2014 9:15:58 AM