Change a text date to standard date

[ja342]

I have text date in query editor and want to convert to standard date, get error message when I try to convert using 'Data Type: Date/Time' and also when I use datefromtext function.

[amitchandak · Accepted solution]

Create new columns like

startdate = mid(Table1[startdatetime],14,2) &"/"& mid(Table1[startdatetime],11,2) & "/" & right(Table1[startdatetime],4)
enddate = mid(Table1[enddatetime],14,2) &"/"& mid(Table1[enddatetime],11,2) & "/" & right(Table1[enddatetime],4)

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin

[Ashish_Mathur · Accepted solution]

Hi,

In the Query Editor, right click on each column individually and go to Split Column > By delimiter > comma.  Remove the column with the time stamp.

Hope this helps.

[ja342]

Awesome thanks, both options worked, one for DAX and other for Query Editor.  cheers!

[Ashish_Mathur]

You are welcome.

[amitchandak · Accepted solution]

Create new columns like

startdate = mid(Table1[startdatetime],14,2) &"/"& mid(Table1[startdatetime],11,2) & "/" & right(Table1[startdatetime],4)
enddate = mid(Table1[enddatetime],14,2) &"/"& mid(Table1[enddatetime],11,2) & "/" & right(Table1[enddatetime],4)

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin