Forum Discussion
text to date
Hello! I need to change the variable of an api I'm working on from text to date, the code is in DAX, how do I do it?
Currently I have a field called "DAY" and this field is configured as text type in my API (which is
my data source), I need to convert this field which is in the format YYYY-MM-DD (text) to DD/MM/YYY (date), as
This way I can automate my query.
Below is an example of one of my attempts to create these variables.
In this case, the period of time I need is from the day before the current day to 35 days before the current day, in order to have the
Automatic Update.
Fowmy
Super User
Super Useralinesilva2
If you date is in text as yyyy-mm-dd then just chagne the data type to date:
You get the result