Forum Discussion

Rookarumba's avatar
Rookarumba
Helper III
8 years ago
Solved

PowerQuery: need help for date.fromtext

Hi All,   I'm wondering what went wrong with "date.fromtext". https://msdn.microsoft.com/en-us/query-bi/m/date-fromtext   I tried it in Excel 2016 and PowerBI Desktop April update   On my end,...
  • v-yuta-msft's avatar
    8 years ago

    Hi Rookarumba,

     

    Date.From("2010-02-19") is a function, "Date.FromText("2010-02-19") equals Date,yyyy-MM-dd" from MSDN is description which explain that you can achieve a date type result when use Date.From() function.

     

    Regards,

    Jimmy Tao