timestamp

Syndicate content

Create either a view with a "Custom Column" of type text that has the following formula:

Int(ToHours([Date Created]-ToTimestamp(ToDate([Date Created])))) & ":" & Int(Mod(ToMinutes([Date Created]-ToTimestamp(ToDate([Date Created]))), 60))

or a formula text field with the same formula.

The formula for "Date Modified" would be:

February 5th, 2009 - 6:02 PM

© 1997-2014 Intuit Inc. All Rights Reserved.

Online Database VeriSign Secured Web Based Software TRUSTe Certification Online Database SSAE Audit