Day Calculation

[Fred in Thailand]

Hi all

Can't figure out how to calculate the number of days left in the current year.

[fabriceN]

date ( 12 ; 31 ; day ( get ( currentDate )) - get ( currentDate )

[Genx]

Minor correction:

date ( 12 ; 31 ; year ( get ( currentDate )) - get ( currentDate )

[Fred in Thailand]

Genx

I assume that that goes in a calc field.

When i do all i get is a ?

Thanks

[Fred in Thailand]

by the way genx thanks for the help on my last little problem

[Genx]

Hi Fred,

No worries.

Make sure that your calculation is unstored and that the result is Number type.

Edited June 20, 2007 by Guest

[Genx]

.. seems there was also a missing bracket:

date ( 12 ; 31 ; year ( get ( currentDate ))) - get ( currentDate )

[Fred in Thailand]

Checked and is as you said.

still "?"

[Fred in Thailand]

That got it... Thanks again

[Genx]

... weird

Go to tools -> data viewer and try it there.

[Genx]

Glad you got it working :P