Hi All
Hi All
i am trying to find a difference between dates using a datediff function. But it say type mismatch. can you let me know
what issue in the below code
Also is it better to use Dateserial instead of datediff
Please Login or Register to view this content.
Never confuse a single defeat to the final defeat.
The first argument, where you use Format, is not a date, it is a String built from the date in FD1. The second argument may work but just in case I would explicitly convert it to a date. Try this:
Please Login or Register to view this content.
Last edited by 6StringJazzer; 03-18-2018 at 08:58 AM.
DateSerial has a completely different purpose than DateDiff. DateDiff tells you the difference between two dates, and DateSerial builds a date from the year, month, and day. You can't swap one for the other.
Hi
just realised the datediff format by which i got the result
DateDiff( interval, date1, date2,)
Please Login or Register to view this content.
Thank you jazzer
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks