How do I calculate the number of days between the current date and a future date that's in a column?
For instance, I'd like to calcultate the number of days the current date and the war.EndDate0 in this query. Select war.EndDate0 as 'Warranty End Date' from v_GS_CUSTOM_WARRANTY_INFO_2_00 war ________________________________ John Marcum Lead Desktop Engineer Bradley Arant Boult Cummings LLP ________________________________ ________________________________ Confidentiality Notice: This e-mail is from a law firm and may be protected by the attorney-client or work product privileges. If you have received this message in error, please notify the sender by replying to this e-mail and then delete it from your computer.
