COMPGROUPS.NET | Search | Post Question | Groups | Stream | About | Register

### Number of days in a year

• Follow

```I have a field that correctly calculates the number of the day of the year
(1-1-2004 is 1, 12-31-2004 is 365) loking like this: DayofYear(Date).

I need the field to display the number with 3 digits 001, 021, 365; not
1,21,365.

Any solutions?  I think it should be simple but I got that think that has
been going around and can't think to the solution.

Rob

```
 0
Reply Zoomer 1/2/2004 7:46:35 PM

```Zoomer <jaxh@pacbell.com> wrote:

> I have a field that correctly calculates the number of the day of the year
> (1-1-2004 is 1, 12-31-2004 is 365) loking like this: DayofYear(Date).
>
> I need the field to display the number with 3 digits 001, 021, 365; not
> 1,21,365.
>
> Any solutions?  I think it should be simple but I got that think that has
> been going around and can't think to the solution.

If you simply need a display, create a Text result calc using

Right( "000" & NumToText(DayofYear(Date)), 3)

Use the DayofYear(Date) field for any numerical calculations. Filemaker
does not display leading zeros in number fields.

Lynn Allen
```
 0
Reply lynn 1/2/2004 8:58:35 PM

```In article <vUjJb.4711\$8c6.3042@newssvr27.news.prodigy.com>,
"Zoomer" <jaxh@pacbell.com> wrote:

> I have a field that correctly calculates the number of the day of the year
> (1-1-2004 is 1, 12-31-2004 is 365) loking like this: DayofYear(Date).

The value for 12-31-2004 should be 366. It's a leap year.

--
Matthew Smith
(to reply via email remove xxx)
```
 0
Reply Matthew 1/2/2004 10:04:55 PM

2 Replies
156 Views

(page loaded in 1.053 seconds)

Similiar Articles:

7/29/2012 2:39:04 AM