Hi there,
I have a variable presented in the YYYYMMDD format within a string, and I’m looking to convert it into the DD/MM/YYYY format for Notion to identify it as a date.
Could you please advise on the best approach for this? I attempted to use the “Set Variable” tool to format it, but I’m not confident in my coding skills.
Thank you in advance!
Hi @DISCURSIVAS_EDUCACAO
The given formatted date can be converted to a date datatype using the parseDate() function.
Eg: parseDate(InputDate;YYYYMMDD)
Now, you can format as per your requirement using the formatDate() function.
MSquare Support
Visit us here
Youtube Channel
Thank you. Your answer was crucial for me in finding the way to pass through it - simple and objective. I’m posting the screenshots below so that everyone in the same situation can solve it too.
