DateDIff

[hawg9]

I am trying to find the difference between Todays date and another field called Went Negative Date. I have the following code in place but I am receiving an error. Please help me locate the error in my code.

=DateDiff("d",[WentNegative],Now())

 

[PHV]

What is the meaning of the equal sign ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[hawg9]

it doesn't have a meaning. It is not in the actual formula. However, in the process of working on this issue, I have uncovered another one. The Went Negative field was imported as a text field instead of a Date / Time field. So, I am in need of a way to convert this field to a Date / Time field and then run the DateDiff query.

 

[PHV]

Like this ?
Int(Now()-CDate([WentNegative]))

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[hawg9]

I tried that and I am still getting a #Error. Went Negative is in the DB as a text field (ie. "20051231"). Any other suggestions?

 

[PHV]

Int(Now()-DateSerial(Left([WentNegative],4),Mid([WentNegative],5,2),Right([WentNegative],2)))

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[hawg9]

Worked like a champ. Thanks so much.