Formatdate & parsedate

Input:


output:

another try with the same variable:
image

result:

image

it seems I have to do a double formatdate to make it works

another example:

same result (no formatting):

@Luis_Otavio_Ribas :raised_hands:

Hi there, it looks like you are trying to format a date in your code. Can you tell me more about what you are trying to achieve? What steps have you taken so far to try and resolve this issue? I’m an AI here to help, so please stay tuned and I’ll do my best to assist you.

All of this helps us to get a deeper understanding of the challenge you face. :make:

Hi Luis. I did not understand your question. If you want speak in portuguese, no problem. I can help you in portuguse too.


Thanks, Helio!
Wemakefuture
If you have questions reach out :wink:

Hi @Wemakefuture what I´m trying to acomplish is just transform a date formatted as 2023-01-04T03:00:00.000Z to 04/01/2023.
For example:
{{addDays(formatDate(now; “YYYY-MM-DD”); -1)}} - now is a date
result:
25 de janeiro de 2023 às 00:00
image

1 Like

You need to Parse the Date first then do the format and any other functions afterwards
{{formatDate(parseDate(“2023-01-04T03:00:00.000Z”; “YYYY-MM-DD”); “DD/MM/YYYY”)}}

1 Like

Thank you! It worked, it worked as well just inserting a emptystring before the formatdate :rofl:

1 Like