Forum Discussion
Rookarumba
8 years agoHelper III
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,...
- 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
v-yuta-msft
8 years agoCommunity Support
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
- Rookarumba8 years agoHelper III
Thanks, that work :)