Date

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

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

A specific report subscription is always emailed at the same time of day (or time of week). However, this time is chosen at random when the report subscription is created.

Currently, the time is randomly chosen in the range from 08:00 to 15:00 UTC time. Depending on daylight savings, this translates into:
Eastern Time: 3AM to 11AM
Pacific Time: 12AM to 8AM

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