creation date

[saranyc1]

This is ridiculous, since I am fairly confident that I've done this before:

I forgot to make auto-enter creation and modification date fields... now of course, I need them. I created them and tried to replace the field contents with a get calc.... I thought for sure there was a Get(CreationDate) or something like that in the design functions....

Any thoughts?

thanks!

[David Jondreau]

Nope. Records don't remember when they were created. If you didn't capture it originally, you won't get it back. Why do you need it now? Can simply replacing that field with today's date so you have some reference point moving forward be helpful.

[saranyc1]

bummer!!! I really thought it was something fm just recorded- kinda like record id.

I mistakenly imported records from two different files without populating the "file year" field. Now I don't know which records belong to which year. I did them on separate days, so I was hoping I could use the creation date to fix my mistake.....

thanks for the heads up.

[David Jondreau]

Well, if you look at the records unsorted, all the records from the first import will be before the records from the second. You just need to find the dividing line. There's nothing else you can use to identify the order of the records? An old primary key? A date on the record that would be odd to come after a date on a previous record?