I am new here and I’m trying to get all the HubSpot deals we have in our system based on a property issue_date. I wanted to convert the given date format, ex. January 13, 2024 to the format 01/13/2024.
Any help would be appreciated. Thanks
Take a look at parseDate() - https://www.make.com/en/help/functions/date---time-functions#parsedate--text--format---timezone--
Take the value of the date and then use this function to output it in whichever format you like.
You can use formatDate function which will change the format of the you issue date. If your issue date is not a valid date, then use parseDate function to make it date.
Here’s an example of format Date function you can use:
