The thread was very interesting to me , as I am currently doing a booking system.
I need to have one record for each day in the year, and I did the ID incrementing from 1999-001 as shown in that thread. ( I must have 1999 and 2000 in place of 99 and 00)And I changed the date to Unix, and its OK.
Now I need the ID to change to 2000-001 when we hit 1999-366.
As I am not very good at Perl, I would appreciate some suggestion how to do this.
Furthermore I have a field called Date, and I would really like to have the date corresponding to the ID written automatically in that field. So that the ID-field shows 1999-031 and the date 31-Jan-1999 is written in the date field.
Any ideas?
[This message has been edited by poulR (edited January 28, 1999).]
I need to have one record for each day in the year, and I did the ID incrementing from 1999-001 as shown in that thread. ( I must have 1999 and 2000 in place of 99 and 00)And I changed the date to Unix, and its OK.
Now I need the ID to change to 2000-001 when we hit 1999-366.
As I am not very good at Perl, I would appreciate some suggestion how to do this.
Furthermore I have a field called Date, and I would really like to have the date corresponding to the ID written automatically in that field. So that the ID-field shows 1999-031 and the date 31-Jan-1999 is written in the date field.
Any ideas?
[This message has been edited by poulR (edited January 28, 1999).]
re: autoincrementing dates