User Profile

Collapse

Profile Sidebar

Collapse
ajp44
ajp44
Last Activity: Nov 2 '15, 10:03 AM
Joined: May 21 '15
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • ajp44
    replied to Date format YYYYMMDD
    in SQL Server
    This is my current query

    But instead of SSJOBH"."Error reporting date">=20150513 I need it to bring back the past 7 days data

    Code:
       SELECT "SSJOBH"."Customer site", "DC_Customers_Payers"."Customer name", "DC_Customers_Payers"."Customer address 1", "DC_Customers_Payers"."Customer address 2", "DC_Customers_Payers"."Customer
    ...
    See more | Go to post
    Last edited by Rabbit; May 21 '15, 04:17 PM. Reason: Please use [code] and [/code] tags when posting code or formatted data.

      Leave a comment:

    • ajp44
      started a topic Date format YYYYMMDD
      in SQL Server

      Date format YYYYMMDD

      Hi

      I am new to SQL coding - need some advice

      I have data with dates but the dates I have are currently "YYYYMMDD" which is fine and I don't want to change

      But the data I wish to bring back needs to be data from the last 7 days

      So

      "Error Reporting Date" minus 7 days

      Thanks
      Andy
      See more | Go to post
      No activity results to display
      Show More
      Working...