Jump to content

Recommended Posts

Good Day,

Has anyone see this before? I have a simple date calculation:  Get(CurrentDate) - DateAccepted   - So for instance, if it was today it would be  03/06/2017 - 03/01/2017 (accepted date) which would give me 5 days. That's fine, works ok.   HOWEVER, when the dates are the same, like 03/06/2017 - 03/06/2017  (so it was received on the current day) I consistently get the number "4"   Should be "0".

This happens between any 2 sets of days, if they are the same. Anyone know why this happens?  It's very strange.

Thanks for any enlightenment on this!

Karen

Edited by Karend440
typo

Share this post


Link to post
Share on other sites

Please check that (1) DateAccepted is a Date field and (2) your calculation is unstored.

Share this post


Link to post
Share on other sites

Something is missing in your description. Can you reproduce the problem in a new file (with only the two fields)? If yes, please post it here.

Share this post


Link to post
Share on other sites

I just did, a new file with the 2 fields and it calculates correctly, so it must be something in my original layout? not sure what to look for. I even recreated the fields,  - made new ones, and they are doing the same thing on the original layout.

Share this post


Link to post
Share on other sites
2 hours ago, Karend440 said:

not sure what to look for.

Me neither. Is the layout where you show these fields a layout of the same table where these fields are defined?

Share this post


Link to post
Share on other sites

Yes, they are all in the same table. I am just going to rebuild the layout tomorrow, and see if I can get it to work that way. There are not that many fields on it.  It's very strange, any dates with the same DateAccepted and the current date are doing this - and always the #4. I will post again after doing so with the results. Thanks again, Comment appreciate your time!

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

×

Important Information

By using this site, you agree to our Terms of Use.