here are my 2 data fields:
I simply want to subtract both, so I can get the number of days between the 2 fields for all 300 rows in a Select statement.
What is the syntax?
Yes I had that earlier.
However, my result is, for example, displaying as as 951603.0000 when it should be just displaying as 1 day.
what can i do??
yes they are DATE types
still getting that strange answer, which is not the number of days between the dates
seems straightforward but driving me crazy...any more ideas???
When I "Select date'2016-11-14' - date'2016-11-13'," I get 1. What are your dates?!?
You could try: cast(MAX(Applied_Date_of_Switch) as date) - cast(MAX(Effective_Date_of_Switch) as date)