wdisneymom Posted February 13, 2005 Share Posted February 13, 2005 I have a lsit of clients who are on a waiting list for services I have a field "today" which changes every day I have a field certification date I need to calculate the time on the waitlist so I did los=today-certification date I get a very long number like 739910 How do I get it right Link to comment Share on other sites More sharing options...
Vaughan Posted February 14, 2005 Share Posted February 14, 2005 change the los field to Get(CurrentDate) - CertificationDate and make sure it is formatted as a number field. The Certification field needs to be a Date field. Link to comment Share on other sites More sharing options...
wdisneymom Posted February 14, 2005 Author Share Posted February 14, 2005 thanks, it worked Link to comment Share on other sites More sharing options...
wdisneymom Posted February 15, 2005 Author Share Posted February 15, 2005 so...why won't the same formula work with today's age get(currentdate)-dob Link to comment Share on other sites More sharing options...
-Queue- Posted February 15, 2005 Share Posted February 15, 2005 Make sure the calc is unstored, so that the date updates. Link to comment Share on other sites More sharing options...
GlennC Posted February 16, 2005 Share Posted February 16, 2005 I'm trying to do date1 - date2 to get then number of days in between. Date1 is more recent. Am not using 'Today' or any function, both dates are already entered into the fields. Calc is formatted to give a number result. It doesn't seem to work. For instance (dd/mm/yyyyy) 03/02/2005 - 06/01/2005 = -5280025 What am I doing wrong? Link to comment Share on other sites More sharing options...
mr_vodka Posted February 16, 2005 Share Posted February 16, 2005 Have you double checked that both Date1 and Daet2 fields are set as "Date fields" ? If they are set to text of number, etc. you sometimes get those long results. Link to comment Share on other sites More sharing options...
-Queue- Posted February 16, 2005 Share Posted February 16, 2005 If that doesn't help, please post a sample of the problem file. Link to comment Share on other sites More sharing options...
GlennC Posted February 16, 2005 Share Posted February 16, 2005 Ahhh.... field 2 was a number field. Not one of my brighter moments. Thanks for the help. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7003 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 accountSign in
Already have an account? Sign in here.
Sign In Now