text to date

[alinesilva2]

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?

[alinesilva2]

I would like to create a variable that identifies the current date, in this case today, and another variable that is the date current -35 days, so that I can do an update automatically, but to do this I believe that I must first
being able to convert the Day field into date format and not Text It is currently in Text format

[Fowmy]

@alinesilva2 

What you are sharing is the "M" code in Power Query. The Date,ToText function is correct. Is question regarding how to do the same in DAX then

FORMAT ( Table[Date] , "yyyy-mm-dd" )

[alinesilva2]

Hi!

I would like to create a variable that identifies the current date, in this case today, and another variable that is the date current -35 days, so that I can do an update automatically, but to do this I believe that I must first
being able to convert the Day field into date format and not Text It is currently in Text format

[Fowmy]

@alinesilva2 

Share some sample date format in text, I will show how to convert it.

[alinesilva2]

My problem is in this part of the code

[Fowmy]

@alinesilva2 
Please provide explanation and the expected result

[alinesilva2]

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]

@alinesilva2 

If you date is in text as yyyy-mm-dd then just chagne the data type to date:

You get the result