November 8, 200421 yr Newbies 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
November 8, 200421 yr Unstored Calculation field with number result: Get ( CurrentDate ) - PastDate. The difference will be in days.
November 8, 200421 yr Author Newbies wow transpower, you're the fastest answer ever!!! thank you very much, i gonna try it now, let you know later... -) thank you!!! schorsch
November 8, 200421 yr Author Newbies 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 :-)
November 8, 200421 yr Get (CurrentDate) is an FMP7 function for FMP6 you need Status (CurrentDate) the calculation should be an unstored number field.
Create an account or sign in to comment