OnDemand User Group

Support Forums => Report Indexing => Topic started by: PasiPK on September 24, 2009, 03:43:30 AM

Title: Automatic Timestamp as key field
Post by: PasiPK on September 24, 2009, 03:43:30 AM

Hello,
would it be possible to have Default Value current timestamp like a Default Value for current date?
I mean in Application/Load Information if there is a date field, you can put Default Value t to get current date.
We have an application which can have multiple loads with same key fields during a day.
Timestamp would be a nice way to differentiate between loads and versions of this data.

Title: Re: Automatic Timestamp as key field
Post by: Bill Dennis on October 01, 2009, 11:04:07 AM

I can't test this right now, but if you create an Application field for TIME and set the format like %H:%M and assign the Default value 't', OD might insert the time of day rather than date.

Title: Re: Automatic Timestamp as key field
Post by: PasiPK on October 05, 2009, 12:10:53 AM

Thanks Bill! That worked. I tried also field with type DATE/TIME and that was fine too.