Forum Discussion
text to date
Super Useralinesilva2
Share some sample date format in text, I will show how to convert it.
My problem is in this part of the code
- Fowmy
alinesilva2
Please provide explanation and the expected resultCurrently 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