Jump to content

Countdown Timer to specified date (IE; Christmas)

This topic is 7564 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.


Link to comment
Share on other sites

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


Link to comment
Share on other sites


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.

Link to comment
Share on other sites

This topic is 7564 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.