Hi all

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

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

Minor correction:

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

Genx

I assume that that goes in a calc field.

When i do all i get is a ?

Thanks

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

Hi Fred,

No worries.

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

Edited June 20, 200719 yr by Guest

.. seems there was also a missing bracket:

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

Checked and is as you said.

still "?"

That got it... Thanks again

... weird

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

Glad you got it working :P