Share via

I'm trying to get week using ISO_Week. The issue is all dates are there but 1 day is missing like 25-Dec .

RXR 121 Reputation points
2020-10-13T05:40:37.1+00:00

Hi @MelissaMa-MSFT
I'm trying to get week using ISO_Week. The issue is all dates are there but 1 day is missing like 25-Dec .

Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,625 questions
Accepted answer
  1. MelissaMa-MSFT 24,196 Reputation points
    2020-10-13T05:52:30.007+00:00

    Hi @RXR ,

    I checked your code and it could be working.

    I also checked the sample.xlsx you provided before, there was no value whose datetime was '2017-12-25'.

    I added one value whose datetime was '2017-12-25 09:00:00' into the sample3 or EventMembershipsDetails table from my side and I could see the row of Dec 25 appeared in the output.

    Could you please check again from your side? Thanks.

    Best regards
    Melissa

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.