question

mwilliamsz avatar image
mwilliamsz asked

SQL 2012 View Statement and number of weeks between 2 dates

Can I get help on the below. 1) I would like to create a View Statement 2) I would need to Count the number of weeks between EVENT_DATE AND GIFT_DATE in the same statement -------------------------------------- SELECT gifts.[FR_ID], CAST (GIFT_DATE as date) as [Gift Date], gifts.[GIFT_AMOUNT], gifts.[CREATION_METHOD], events.[NAME], CAST (EVENT_DATE as date) as [Event Date], events.[EVENT_TYPE], events.[FISCAL_YEAR] FROM gifts INNER JOIN events ON gifts.FR_ID = events.FR_ID Thank you
sql server 2012
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.