Count Down Timer

[Qam Qam]

Hello everyone ,

this is my 1st post in this helpful website 

thank you guys ive learned a lot 

 

iam working on recruiting software for my office 

its simple 

my issue now that i want to set simple days count down timer 

for example if my client requested his procedure finish in 60 days or 90 days 

i want to know left days in a list so i can give pioirty 

so i used the following 

GetAsNumber ( Contract_End_Date - Get ( CurrentDate ) )      

which appears in the remaining days filed 

it worked fine for me 

the issue is 

it remains  frozen , next day its the same value like yesterday 

 

sorry for my bad English '

 

please help me 

thank you 

[Ocean West]

your calculation value must be "un-stored" this way it will always evaluate to the current value. Choose storage options

 

 

[Qam Qam]

thank you very mch sir for replaying 

i have the below mentioned options in the storage 

what do i choose 

[IdealData]

Your field must be a CALCULATION field, the storage options are then available at the bottom of the calculation definition.

 You have defined a NUMBER field with Auto-enter options and so your data is STORED. This means the field will not re-evaluate and will hold the initial value unless "Contract_End_Date" is changed.

[Qam Qam]

thank you very much sir for replaying 

is this the correct  way 

 

[Qam Qam]

anyone

[Ocean West]

Just subtract the two days to result in number of days.  

ContractEndDate - Get(CurrentDate) 

The result will be a positive number as long as the contract date is a future date you may want to add logic if you want it not to show a negative number if the contract is expired.

There are also many Custom Functions that can also help if you need to calculate for business days etc  http://www.briandunning.com/filemaker-custom-functions/list.php you can search for dates or count etc. 

 

[Lee Smith]

Hi Qam Qam and welcome to the FM Forums,

The link provided by Ocean West is an excellent resource. If you do a search for Date you will get 331 hits.

The Custom Functions site, http://www.fmfunctions.com/functions.php is another good resource with 28 dates.

I made a quick and dirty file that shows your calculation with a positive number, and I added some Conditional Formatting. There are two other count fields showing Inclusive Dates and and Work Days instead of straight date plus.

HTH

Lee

 

Count Down Timer.fmp12

[IdealData]

Yes, your field definition now looks correct.

[Qam Qam]

On 4/12/2018 at 5:57 AM, Lee Smith said:

Hi Qam Qam and welcome to the FM Forums,

The link provided by Ocean West is an excellent resource. If you do a search for Date you will get 331 hits.

The Custom Functions site, http://www.fmfunctions.com/functions.php is another good resource with 28 dates.

I made a quick and dirty file that shows your calculation with a positive number, and I added some Conditional Formatting. There are two other count fields showing Inclusive Dates and and Work Days instead of straight date plus.

HTH

Lee

 

Count Down Timer.fmp12

thank you very much this is very helpful 

On 4/12/2018 at 11:51 AM, IdealData said:

Yes, your field definition now looks correct.

thank you