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 March 6, 20178 yr by Karend440
typo

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

Thanks Comment. Yes to both. They were set correctly.

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.

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.

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?

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!