format issue - i think

[aoswald]

i am using this formula:

expr2: DateDiff("yyyy",[hiredate],Now())+1

it returns the correct number for example the first record is 1/15/1900. The 15 is correct but why is it giving it to me in this date format?

thanks

 

[dkinley]

You have ... DateDiff("yyyy",[hiredate],Now())+1

Try .... DateDiff("yyyy",[hiredate],Now()+1)

-dK

 

[namliam]

Because your field is formatted as a date.

Dates are basicaly real numbers only formatted differently. Check your field format and remove it.

 

[aoswald]

change in formula returned same result

removing the format fixed it

thanks so much for the response

 

[dkinley]

Ah .... thanks for posting back the solution!

-dK

 

[namliam]

Great! Happy coding!

 

[boblarson]

Also, another aside (seems I'm putting forth a few of these tonight):

If you have your [hiredate] field, don't use NOW, use DATE instead as NOW includes time whereas DATE uses only the date portion.