Forum Discussion
Data type is wrong?
Nowhere. It was just an example to illustrate the solution.
In your case, go to the Query Editor, select your column with textual dates and adjust the data type using Locale.
The video below illustrates how; it starts already in the Query Editor.
Here is the Query Editor
I dont think that the syntax is the problem. I'm guessing that the problem is on the date formats.
In that case you have more than 1 problem.
You can convert text dates to real dates in the Query Editor.
And still you need to provide the earlier date as the first parameter to DATEDIFF.
You may think otherwise, but the syntax is quite clear:
DATEDIFF(<start_date>, <end_date>, <interval>)
You may consider providing more information if you want helpful help.
This query TPA Portfolio:
let Source = #table(type table[Last Update Date = text],{{"31/12/2017"}}), #"Changed Type" = Table.TransformColumnTypes(Source,{{"Last Update Date", type date}}, "es-AR") in #"Changed Type"works fine with this custom column:
Days since Last Update = DATEDIFF('TPA Portfolio'[Last Update Date],TODAY(),DAY)Convinced?
First of all, I appreciate your help.
Where do I have to insert that syntax function?
let Source = #table(type table[Last Update Date = text],{{"31/12/2017"}}), #"Changed Type" = Table.TransformColumnTypes(Source,{{"Last Update Date", type date}}, "es-AR") in #"Changed Type"Nowhere. It was just an example to illustrate the solution.
In your case, go to the Query Editor, select your column with textual dates and adjust the data type using Locale.
The video below illustrates how; it starts already in the Query Editor.
Here is the Query Editor