Forum Discussion

alinesilva2's avatar
alinesilva2
Regular Visitor
2 years ago

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?
alinesilva2's avatar
alinesilva2
Regular Visitor
2 years ago

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's avatar
Fowmy
Icon for Super User rankSuper User
2 years ago

alinesilva2 

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


  • alinesilva2's avatar
    alinesilva2
    Regular Visitor
    2 years ago

    My problem is in this part of the code

    • Fowmy's avatar
      Fowmy
      Icon for Super User rankSuper User
      2 years ago

      alinesilva2 
      Please provide explanation and the expected result

      • alinesilva2's avatar
        alinesilva2
        Regular Visitor
        2 years ago

         

        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.