Hi guys

I am trying to figure out a way of having a countdown timer to a specified date that never changes such as Christmas Day or July 4th (as opposed to say Easter) so for example if today was December 1st my calculation script would return a numerical answer of 24. Being the remaining number of days till Christmas Day. If I was counting down to July 4th and the current date was June 29th the calculation would return '5'.

Can anyone help me or suggest an easy calculation.

aTdHvAaNnKcSe

Hi Nelly,

This should do the trick if its a fixed date you never want to change:

Define a unstored calculation field, result equal to Number, with the following calculation

Date(12; 24; 2003) - Status(CurrentDate)

If you want to be able to enter any date in the future, and see how many days there are until that date, you need to define a Date field, which must be validated by a calculation that the date is higher than the current date, and change the above unstored calculation field to use that instead of the Date function.

I have enclosed a small testdatabase in fp5 format which you can download and see the definitions.

Just my 0.02

testdate.zip

Excellent!

Thanks a bunch, worked like a dream and didn't think it would be as simple as that. I have another one, possibly as simple?

If I have a start time for an event and a finish time, how do I work out the duration of the event? I have tried to use the following but to no avail...Can you show me where I am going wrong?

(Time(Start Time, Start Time, Start Time) - Time(Finish Time, Finish Time, Finish Time))

Many thanks.

Fastest way to show you is in the field definitions of the enclosed small FP5 database.

Just my 0.02

TestTime.zip

great thanks very much!