Discussion Locked

Date converison help

0 helpful

2 replies

by jeng181 Jun 24, 2009 last reply Jun 24, 2009 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have and effective date and a cancelaltion date. I need to count the total days of coverage.

how would i add this to my query?

2 replies

I asume SQL, but which flavor of SQL?

look up the datediff function, in whatever version of SQL you are using.

This discussion is closed to new replies.