Is there a date field defined in the table that has the needed date? if so, you can do this. If not, you have a problem. You either won't be able to do this for past records or you'll have to assign some arbitrary date to the date portion of the timestamp.
Luckily, I do have a date field that is set as date and auto-populates upon creation. I have looked and can only find how to convert from timestamp to date, and not vice versa.
1 of 1 people found this helpful
To produce a timestamp, you have to combine the dates and times in the same expression. The following both work:
There's a TimeStamp function you can use like this: TimeStamp ( DateFIeld ; TimeField )
And there is also GetAsTimeStamp ( DateField & " " & TimeField )
If you set up a new field to auto-enter a creation time stamp, you can use Replace Field contents with either of those two functions to populate your existing records with creation timestamp data. Or you can continue to auto-enter creation dates and times in separate fields and just add a calculation field with one of these expressions so produce the time stamp.
ok. the issue is that i don't have a time field. so, if filemaker doesn't store the timestamp in the background of the date created, then i have no way of extracting that info, correct?
Yes, that data is not accessible unless you have specifically captured that data in a field for each record. You could set up a timestamp that had the date and an arbitrary time such as 12 pm and future records could auto-enter the complete timestamp
that's what i thought...ok. it was worth the effort. GIGO, right?