Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: JK M
  Where is JK M?
 Meycauayan City
 Philippines
 JK M
 To: Koen Piller
  Where is Koen Piller?
 Santpoort-Zuid
 Netherlands
 Koen Piller
 Tags
Subject: RE: help on date and auto numbering..
Thread ID: 268549 Message ID: 268597 # Views: 29 # Ratings: 0
Version: Visual FoxPro 6 Category: VFP and .NET
Date: Tuesday, July 13, 2010 2:37:01 PM         
   


> > Hey there everyone, can you help me, what I want to happen is to create a program which has an auto-incrementing control number, which restarts back to 001 when the year changes, for example:
> >
> > 10-21
> > 10-22
> > 11-01
> >
> > 10-21 where 10 is the last part of the current year(2010) and 21 is the auto incrementing number..
> >
> > I'm having a bit of a hard time figuring this one out..
>
>
>
> Hi,
>
> What is the condition for the next number? date or reccord ?
>
> id controlnumb date field
> 1 10-01 01.01.2010 appels
> 2. 10-02 01.01.2010 pears
> 3. 10-03 01.03.2010 appels
>
> or
>
> 1. 10-01 01.01.2010 appels
> 2. 10-02 01.02.2010 pears
> 3. 10-03 01.04.2010 appels
>
> Regards,
>
> Koen

Hey Sir Koen, 10-01 where 10 is the last 2 parts of the current year which is 2010, and 01,02,03 are like IDnumbers, which start from 01 and will reset to 01 again if the current year changes from 2010 to 2011, therefore creating 11-01..

ENTIRE THREAD

help on date and auto numbering.. Posted by JK M @ 7/13/2010 8:25:45 AM
RE: help on date and auto numbering.. Posted by Bhushan Sahni @ 7/13/2010 8:33:38 AM
RE: help on date and auto numbering.. Posted by JK M @ 7/13/2010 11:48:02 AM
RE: help on date and auto numbering.. Posted by Samir H. @ 7/13/2010 2:52:50 PM
RE: help on date and auto numbering.. Posted by JK M @ 7/13/2010 3:01:08 PM
RE: help on date and auto numbering.. Posted by Koen Piller @ 7/13/2010 12:56:39 PM
RE: help on date and auto numbering.. Posted by JK M @ 7/13/2010 2:37:01 PM
RE: help on date and auto numbering.. Posted by Koen Piller @ 7/13/2010 3:03:03 PM
RE: help on date and auto numbering.. Posted by JK M @ 7/13/2010 3:15:09 PM
RE: help on date and auto numbering.. Posted by ho me @ 7/14/2010 5:58:21 PM
RE: help on date and auto numbering.. Posted by Christian Tabligan @ 7/15/2010 2:57:22 AM
RE: help on date and auto numbering.. Posted by JK M @ 7/15/2010 5:51:26 AM
RE: help on date and auto numbering.. Posted by Christian Tabligan @ 7/15/2010 6:20:28 AM