date created

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 - 5:02 PM

You can create a formula field of type text that has the following formula:

List("-",ToText(Year(ToDate([Date Created]))),Right("0" & ToText(Month(ToDate([Date Created]))),2),Right("0" & ToText(Day(ToDate([Date Created]))),2))

February 5th, 2009 - 5:02 PM

© 1997-2014 Intuit Inc. All Rights Reserved.

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