Include year number into the nummer format

[hubabubaa]

i need to make a numbering system that includes the year count.

the example is nr 05-001, 05-002, 05-003 etc..

05 is the current year, it has to be kept up to end of 2005. 001 is a consecutive number, goes up with every new entry, till the end of the year.

then on 1 january 2006 it has to star from the beginning and become 06-001.

anyone idea how to do it?

thanx a lot!

[RalphL]

Look at the FMI TeckInfo Knowledge Base.

Here aer some items that may help:

104599

104601

104385

104336

103588

[-Queue-]

See a sample file here.

[hubabubaa]

hi,

i checked your example, but it does not work.i have FM 7. the problem is that the number stays 05-001 all the time, does not increase at all. do you know where the problem could be?

huba

[hubabubaa]

i am quite new to FM.

so my question is: where can i find the FMI TeckInfo Knowledge Base?

huba

[SlimJim]

(With regard to Queue's example)

I assume you allowed FMP7 to convert from the original .fp5 files. I think the problems lies in the interpretation of the self-join (I can't look at the fp5 file but I'm sure that is how it is done). You need to change the definition of the Incrementor Auto-Enter from

GetField("PseudoSerial::PseudoSerial") + 1

to

GetField("PseudoSerial 2::PseudoSerial") + 1

PseudoSerial 2 is the name that FMP7 gives the second Table Occurrence of PseudoSerial on conversion.

Edited July 21, 2005 by Guest
To specify which post I was replaying to.

[hubabubaa]

BINGO! that was it!

thanks a lot,

huba

[hubabubaa]

I thought i got it right, but...

it seems to work when i put it all in my base, but only for the first two records. i get thus 05-001, then properly 05-002. but all the following record stays on 05-002. any idea where i made mistake?

h.

[RalphL]

Are these new records?

Do you have Incrementer set as Number, Auto enter Calculation, Evaluate always?

Do you have PseudoSerial set as Text, Auto enter Calcaulation, Can't modify?

Both auto enter calcaulations should be set to Not replace existing value.

[SlimJim]

In addition to the checks suggested by RalphL verify that in the relationship defined between PseudoSerial and PseudoSerial 2 the records in PseudoSerial 2 are sorted in descending order by Incrementor. Your symptoms suggest that that sort order is incorrect.

[-Queue-]

Oy vey! It would have helped if you had listed your version number. Sorry for the confusion anyway. Attached is the converted solution. All I had to do was change the GetField definition after conversion. I am not sure what your problem is.

PseudoSerial.zip

[hubabubaa]

hey guys (i assume),

thank you for your help , i am there already!

huba