how to change text to date

[majdkaid22]

Hi,

I have data coming from SalesForce. BI is not recognising the date as date. when changing the type to date, am left with so many errors, which is quite strange, as the date in the error tab is still formatted in the same way of the correct ones.

I tried few methods that I know, but none worked. I changed the value of / with none and then tried to workout the CALCULATING the Infraction Date but it didn't perform as expected due to the number of characters are not equal in all rows.

Any thoughts to help in a solution? 

[Anonymous]

Hi, i have a semilar problem...

If i want to change text to date, i got some errors which i can't explain to myself. The "error dates" aren't different then the ok once.

Any thoughts to help in a solution?  Thanks in advance!

[arify · Accepted solution]

Looks like you're parsing a "DD/MM/YYYY" format, but your workbook's culture is "MM/DD/YYYY". Luckily, Date.FromText takes an optional culture parameter. Can you try Date.FromText([CreateDate], "en-GB") ?

[sebbyp]

Great!  Worked for me as well

[majdkaid22]

It indeed has worked @arify 

Thanks mate