topic Re: Changing Date Format in Recipe for Google Drive Folders in Community Chat

Changing Date Format in Recipe for Google Drive Folders

energidi — Mon, 30 Dec 2024 14:12:08 GMT

Hi everyone,

I have a Workato recipe that connects Salesforce with Google Drive.
In the recipe, I’m creating Google Drive folders where the folder names are based on Contact names and their Date of Birth.

This setup works perfectly.

However, I want to change the Date of Birth format, which comes from the 'Date_of_Birth__c' Contact date field, from YYYY-MM-DD to MM-DD-YYYY.

How can this be achieved?

Re: Changing Date Format in Recipe for Google Drive Folders

theiiienrique — Mon, 06 Jan 2025 21:31:19 GMT

Hi @energidi, you can use the strftime formula to achieve this.

Example:

Re: Changing Date Format in Recipe for Google Drive Folders

Obugari — Tue, 12 Aug 2025 07:17:22 GMT

Hi @energidi ,
you can change the format using date formula .strftime("MM-DD-YYYY") and .to_date(format: "MM-DD-YYYY")

Re: Changing Date Format in Recipe for Google Drive Folders

shivakumara — Thu, 14 Aug 2025 13:02:40 GMT

Hi @Obugari ,
Correction:
Using to_date will not produce the desired output in this case, as it is specifically designed to convert input data into a date format and returns it as YYYY-MM-DD. If you run the formula as suggested earlier, it will result in an error.

Preferred Solution:
Instead, using strftime is recommended. It allows you to format the date into any desired output format, giving more flexibility to meet end-user requirements.

Conclusion:

to_date: Converts a string to a date using a specified input format and returns it in YYYY-MM-DD.
strftime: Formats a date into a custom output format as required by the user.

Thanks and Regards,
Shivakumar K A

Re: Changing Date Format in Recipe for Google Drive Folders

Obugari — Mon, 18 Aug 2025 08:24:41 GMT

Hi @shivakumara ,

Thanks for clarification , but in workato docs they have mentioned we can use the format also. I will try that and let you know on this

Re: Changing Date Format in Recipe for Google Drive Folders

shivakumara — Mon, 18 Aug 2025 09:02:37 GMT

@Obugari Agreed, we can use it in formula mode. However, the key point here is the format talks about the input provided by the user.

Thanks and Regards,
Shivakumara K A