topic Re: Changing Date Format in Recipe for Google Drive Folders in Workato Pros Discussion Board

Changing Date Format in Recipe for Google Drive Folders

energidi — Tue, 31 Dec 2024 05:43:13 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

rachelnatik — Tue, 31 Dec 2024 14:25:18 GMT

There are several date formulas that can accomplish this.

Re: Changing Date Format in Recipe for Google Drive Folders

gary1 — Tue, 31 Dec 2024 16:40:12 GMT

Use this:

"2020-12-12".strftime("%m-%d-%Y")

Re: Changing Date Format in Recipe for Google Drive Folders

energidi — Thu, 02 Jan 2025 07:07:54 GMT

Thank you, @gary1 !
The formula works perfectly when written as follows:

[Date_of_Birth__c]=.strftime("%m-%d-%Y")
(The 'Date_of_Birth__c' field is sourced from an output).

However, attempting the formula below, which is what I need, results in the error: Formula has errors

[ContactName__c]_[Date_of_Birth__c]=.strftime("%m-%d-%Y")
(The 'ContactName__c' field is sourced from an output).

Even after removing the underscore, the error persists.

Re: Changing Date Format in Recipe for Google Drive Folders

Ozdemira — Thu, 02 Jan 2025 09:05:23 GMT

this should work: "#{ContactName__c}_" + Date_of_Birth__c.strftime('%m-%d-%Y')
Is it recognised as a date/time string? If not you can parse it to a date time format:

"#{ContactName__c}_" + Date.parse(Date_of_Birth__c).strftime('%m-%d-%Y')

Maybe try the To-date formula see if it recognises it as a datetim? https://docs.workato.com/formulas/date-formulas.html#to-date

Re: Changing Date Format in Recipe for Google Drive Folders

Prudvi — Thu, 02 Jan 2025 09:09:26 GMT

Hi @energidi ,
The formula error which you see is because you are converting the date field to string.
And when we are using a formula toggle option, we must concatenate it to the strings.

Example : [ContactName]+"_"+[DOB].strftime("%m-%d-%Y"))
Can you please check.
Regards,
Prudvi

Re: Changing Date Format in Recipe for Google Drive Folders

shivakumara — Thu, 02 Jan 2025 13:18:30 GMT

Hi @energidi ,
solution:

Image_1: If the incoming date field is of type Date, there is no need to convert it to Date again. However, make note of the brackets.
Image_2: If the incoming date field is of type String, it is required to convert the source field to Date (i.e., strftime works on the Date field).

Thanks and Regards,
Shivakumara Avadhani

Re: Changing Date Format in Recipe for Google Drive Folders

energidi — Mon, 06 Jan 2025 09:15:20 GMT

Hello @shivakumara

Your solution (image 1) worked.
Thank you very much!!!

Re: Changing Date Format in Recipe for Google Drive Folders

shivakumara — Mon, 06 Jan 2025 15:42:50 GMT

Hi @energidi ,
Glad to hear that. Happy to help.

Thanks and Regards,
Shivakumara A