Six digit date from date stamp

[Drew Sanderson]

Hello all,

The client I am developing for uses a Stock ID number for each individual piece he sells. Each piece is unique and has a unique number. Part of this number is the six digit date (MMDDYY) the item was received.

Is there a way to convert an auto-enter date (MM/DD/YYYY) that is made with each new record to just MMDDYY so I can use it in a calculation to help automatically created the stock ID number?

Thanks

Drew

[Søren Dyhr]

I would never use anything but serial autoenters for ID'ing a record!

Beyond that lets apply the Sinatra doctrine:

Right("0" & Month ( theDate );2) &

Right("0" & Day ( theDate );2) &

Right(Year ( theDate );2)

--sd

[Drew Sanderson]

Thanks for the advise. I actaully am using an autoenter in the background for all realationships. I just have to implement a system they are used to seeing.

I am quite new to FMP and was not sure how to implement your calculation. How exactly do i have it reference to a date say from a time stamp or one choosen from the pop up calendar feature.

Thanks for the help :

Drew

[Drew Sanderson]

I made it work!!! Thanks so much! For anyone else in my shoes of being a novice, I just put the field for time stamp which is created at record creating in the ( theDate)

Edited September 1, 2006 by Guest