Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: teralearner
- Content: Threads
- Order by date
-
Number of working days between two date fields
I need to calculate number of working days between two date fields. Any sugestions? I am a SAS user. I am able to use SAS MACRO to write a query like this: select date2 - date1 + 1 as days0, case when '2002-01-01' between date1 and date2 then days0 - 1 else days0 end as days1...- teralearner
- Thread
- Replies: 4
- Forum: NCR: Teradata
