Share via

utcNow() has issues with data preview ('preview data' when using convert to eastern standard time.

Anonymous
2023-09-06T19:47:58+00:00

I have a file in the blob and we do convert and load datetime from utc to eastern standard. While using copy data, if I try to preview, please refer to the attached.

Microsoft 365 and Office | Word | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-09-06T23:05:09+00:00

    Hello

    I’m Adeyemi and I’d be happy to help you with your question.

    It sounds like you're having trouble with the utcNow() function when previewing data in a copy activity that converts and loads datetime from UTC to Eastern Standard Time. Here are some general suggestions that might help:

    1. Check the format of the datetime values: Make sure that the datetime values in your source data are correctly formatted and can be recognized by the utcNow() function.
    2. Check the mapping of the datetime column: Make sure that the mapping of the datetime column in your copy activity is correct and that the values are being correctly converted from UTC to Eastern Standard Time.
    3. Check for errors in the copy activity: Check the output of the copy activity for any errors or warnings that might indicate what's causing the issue with the utcNow() function.

    I hope this helps!

    Give back to the Community. Help the next person who has this issue by indicating if this reply solved your problem. Click Yes or No below

    Regards Adeyemi

    Was this answer helpful?

    0 comments