DATETOTEXT(TODAY, "yyyy-MM-dd-HH-mm-ss")

Correct me if I'm wrong, but the output of that seems to look like this "2012-02-16-00-00-00". its not adding the hh-mm-ss Is that expected?

Greg

Ah, sorry. Yes. My mistake. TODAY means today's date, with time zeroed-out. I should have used NOW:
DATETOTEXT(NOW, "yyyy-MM-dd-HH-mm-ss")

UGH. No idea how I missed the existence of the NOW function in the first place. I should have known you guys had thought of everything. ;)

Hi Steve and Schergr,
Thanks for your help on Timestamping.

We would like to figure out how to create a new Record with an updated Timestamp whenever any Field in the original Record is edited or updated. (keeping the original Record intact)
The objective is to create a complete timestamped archive of all log entries or amendments.

Can you suggest a way to do this?

How do the edits occur?

edits occur through manual edits in Omniscope Dataexplorer

we wish to use this to create a procedure for logging and timestamping all edits to a table that may be updated by any of a number of users at any time.

I've reclassified this as an Idea - please vote.

Summary:
An option to configure a "last-edited" timestamp column in Omniscope, non-editable, automatically updated by Omniscope when cells in that record are modified.

Note that you might also be able to achieve this separately to Omniscope by using a database.

Yes, a database would do this, but it would be fantastic to be able to do this within Omniscope, so you don't have to go back and forth.