calculate elapsed days...

[schorschcaco]

hello everybody!

i'm trying to do a calculation for the period between today and a day in the past, lets say the 3rd of november. how must i calculate, so that fm is giving the numer of days elapsed since then? I use this number for a calculation later on...

thanks al lot for helping!

schorsch from switzerland

[transpower]

Unstored Calculation field with number result: Get ( CurrentDate ) - PastDate. The difference will be in days.

[schorschcaco]

wow transpower, you're the fastest answer ever!!! thank you very much, i gonna try it now, let you know later... -)

thank you!!!

schorsch

[schorschcaco]

hello again... -)

Get(current Date) didn't work, so i took getField (current date), it worked, but it gives me a huge negative number (seconds???), although the past date is smaller then the current date... what did i wrong?

looking forward to your answer...

schorsch with too many days :-)

[RalphL]

Get (CurrentDate) is an FMP7 function for FMP6 you need Status (CurrentDate) the calculation should be an unstored number field.

[transpower]

Sorry, I forgot to check your version number. Ralph is right.