Countdown Timer to specified date (IE; Christmas)

[Nelly]

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

[Johds]

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

[Nelly]

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.

[Johds]

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

Just my 0.02

TestTime.zip

[Nelly]

great thanks very much!