+ Reply to Thread
Results 1 to 1 of 1

Dates problem in PowerQuery

  1. #1
    Registered User
    Join Date
    05-04-2020
    Location
    Egypt
    MS-Off Ver
    Office 2016/2019
    Posts
    20

    Dates problem in PowerQuery

    Please note that I have a report that include multiple columns I used to convert its output with PowerQuery, the problem is the "Dates" column not all its input is the same, and what I want is to be read as "dd-MM-yyyy" format, but PowerQuery return error for some dates while some others are read as date.
    Any solution will be highly appreciated for the sample dates column in the attached file (1 sheet for the source data & 1 sheet for PowerQuery Output that converted errors to null)
    If certain steps is required for the solutions will be highly appreciated if mentioned in details as I'm still new in PowerQuery
    Thanks in advance.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. PowerQuery index match prioritized criteria from 2 columns
    By Imbizile in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-28-2020, 08:52 AM
  2. PowerQuery
    By wherdzik in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-08-2020, 03:03 PM
  3. PowerQuery in Excel: Use an Excel table to populate SQL table in PowerQuery
    By joeyslaptop in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-25-2019, 02:33 PM
  4. [SOLVED] Excel / powerquery formula to compare dates/time when other value is matching.
    By B4dTweety in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-27-2019, 10:15 AM
  5. VBA vs PowerQuery
    By Trachr in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-08-2017, 11:50 PM
  6. PowerQuery and VBA
    By Trachr in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-08-2017, 12:10 AM
  7. Help with powerquery.
    By stephme55 in forum Excel General
    Replies: 0
    Last Post: 09-01-2016, 07:31 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1