Elapsed number of days

[Opieos]

Hey gang:

I currently have a database that I'm working on. I'm looking to be able to enter the creation date for a record and then use the current date to get the number of days that have elapsed since the record was entered.

example date created 01/23/08 current date 01/24/08 leaves a field which shows 1 day.

Any help is greatly appreciated.

Thank you

Edited January 23, 2008 by Guest

[aaa]

Hi, Opieos!

Create unstored calc field:

Get(CurrentDate)-Date_Created

[Opieos]

Thank you soo much..

Note to self when trying to do a calculation and fill in a field make sure that your text isn't white on a white background....spent about 2 hours banging my head on the desk today! :)

[LaRetta]

:giggle: Ah, Opieos, they say you'll never be a great rider unless you've been bucked off a thousand times. White text on white background is a small buck indeed. Continue to make a lot of mistakes; continue to overlook, underestimate and overdo everything in FM and you'll be very great. The secret is ... you are DOING. Many talk the talk but don't put in the time and sweat and simply don't make enough mistakes.

Take me for example - nobody has made more mistakes than I have except for those who are far greater. And when someone next posts that their text doesn't show, you'll be right there with, "Ah, did you make sure the text is black?" I keep telling myself that it is usually the little things; few bugs; mostly little things. Good on you for being big enough to admit it. I really like that in a person.

Now ... if you knew me like many here know me - that last sentence would bother you a great deal.

LaRetta