none
Help filtering down to date RRS feed

  • General discussion

  • Hi all, 

    I have a Query that I need to select down to the date and I cant figure out a where statement to pull to a yyyy-mm-dd format. 

    Currently the modified date time is set to the milisecond - 2018-12-12 22:04:53.030. 

    I would like to only return fields from the day prior. 

    /****** Script for SelectTopNRows command from SSMS  ******/
    SELECT 
    b.Name
          ,a.[ScheduleUnit]
          ,a.[SchedID]
          ,a.[ChangeID]
          ,a.[Action]
          ,a.[ShiftID]
          ,a.[StaffNum]
          ,a.[ShiftDate]
          ,a.[ChangeReason]
          ,a.[ChangeReasonDesc]
          ,a.[ModifiedStaffNum]
      ,a.[ModifiedDateTime]
      FROM [PR_PS3_Report].[bu].[vw_SchedulePublishedChanges] as a
      Inner join [PR_PS3_Report].[bu].[vw_Staff] as b on a.ModifiedStaffNum = b.StaffNum

    Wednesday, October 28, 2020 10:41 PM

All replies

  • Hello Hitesh,

    This forum is dedicated to supporting issues related to open specification. You can access open specifications at https://docs.microsoft.com/en-us/openspecs/. Your inquiry does not seem to be related to open specifications.

    For a better chance of getting an answer to your question, you may want to post your question to the following forum:

    https://docs.microsoft.com/en-us/answers/products/sql-server

    Regards,
    Sreekanth Nadendla
    Microsoft Windows Open Specifications
    Thursday, October 29, 2020 3:42 PM
    Moderator
  • https://support.klipfolio.com/hc/en-us/community/posts/360000120074-New-Date-Filtering-Date-Drop-Down-Period-Selector
    Sunday, November 1, 2020 10:46 AM