Forum Discussion
Data type is wrong?
Hi guys! First of all Happy New Year. I´m working on a report for my work which has a lot of projects with their respective last update on the database. I´m making a function that calculates the ...
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
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