302 Found

Found

The document has moved here.

day

Syndicate content

1. I have a time of day field set up as military time but when it exports to Excel it converts to normal time and adds AM/PM.

For example, 18:00 exports as 6:00 PM.

2. I have a duration field that is exporting differently than on the view.

For example, 2:30 exports as 2.5 hours.

February 5th, 2009 - 6:02 PM

Create a report with a custom formula column of type "Text". Use the following formula:

Case(DayOfWeek([Your Date Field's Name]), 0, "Sunday", 1, "Monday", 2, "Tuesday", 3, "Wednesday", 4, "Thursday", 5, "Friday", 6, "Saturday")

Then sort and group on the custom column.

February 5th, 2009 - 6:02 PM

Here is a formula that will calculate the third Friday of the current month:

NextDayOfWeek( FirstDayOfMonth(Today()) - Days(1), 5 ) + Weeks(2)

It can be broken down to the following steps:

1) find the first day of the month containing today
2) go back one day to the last day of the previous month
3) find the next Friday (the number 5 represents Friday)

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 view 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
302 Found

Found

The document has moved here.