Date Delemma

[DarwinsDatabase]

I am struggling with the DateDiff fuction in a calculated field. After some study, I have used several variations of:

=(DateDiff("d",[DUED],Date())/7)

to calculate the time (in weeks) until a due date starting from today's date.

It continually turns up a specific date in the late 18 and early 1900's. It does not give me the number in weeks which was what I was hoping for.

Earlier I used a very simple: =DateDiff("m",[Birthdate],Date()) to calculate the age from a date of birth perfectly with no problems.

I do not understand why the formula is not working. Does it have to do with format or the fact that I am working with a future date and how can I rectify this problem? I would very much appreciate some input and would like to thank you for your time in advance.

 

[mrojas]

Is [DUED] known?
If so, if I use, say 1/12/1999 and today's date, and divide the result by 7, the answer I get is 765.414
This number represents weeks.
I'm not sure what exactly you're trying to calculate. A date in the future? In the past?

 

[plog]

It continually turns up a specific date in the late 18 and early 1900's

That sentence is logically inconsistent: 'continually turns up a specific date' means that its returning one date. 'in the late 18 and early 1900's' are mutually exclusive timeframes, which implies more than one date.

Add to that my knowledge that DateDiff doesn't return a date (it returns a number) at all, and you've completely lost me. When dealing with technical information, you need to be very technically accurate.

Here's my questions to you:

1. What field type is [DUED]? Is it in fact a Date/Time field?

2. Can you give me 3 examples of values for [DUED] and what you get as results from that function when you plug those values in?

 

[DarwinsDatabase]

Thank you for responding.

"Is [DUED] known?"

[DueD] is the name of the variable field that will be entered by users. I would like a calculated field telling them the weeks between the Due Date and today's date.
​

"I'm not sure what exactly you're trying to calculate. A date in the future? In the past?"

I am calculating the difference between today and a due date in the future. I would like it returned in weeks. I will use December 25th, 2013 as an example of a due date. My calculated field returns:
​

15/12/1899
​

Thank you.

 

[DarwinsDatabase]

Thank you I solved it. It was a formatting problem. Thank you Plog for questioning what type of field it was. I just removed all formatting from the field and it returned the weeks. Thank you.