question Date to string transform in flow designer in ServiceNow AI Platform forum

Date to string transform in flow designer

marclindsay — Tue, 25 Feb 2025 03:49:16 GMT

I have a sub-flow input variable that is a Date.

Need to convert this to a string in the format yyyy/MM/dd.

Using the "Date to String" transform to pass this to an Action.

Keeps the date in the format MM/dd/yyyy. Does not change the format.

Also noticed this comment in the logs:

2025-02-25 03:37:36 .....Warning.....DATE_TO_STRING with name com.glide.transform.adapter.DateToStringAdapterRule: Failed to parse input: Unparseable date: "02/24/2025"

I am also using the Key Value Map transform and that works perfectly fine. Not sure why the Date to String transform will not work.

Re: Date to string transform in flow designer

DeependraS — Tue, 25 Feb 2025 04:04:53 GMT

Instead of Date to String, try using the Format Date Action in Flow Designer:

Go to your Flow Add Action → Data Manipulation → Format Date

Input Date: Your sub-flow date variable

Date Format: yyyy/MM/dd

Use the formatted output in the Action

Re: Date to string transform in flow designer

marclindsay — Tue, 25 Feb 2025 04:23:32 GMT

I don't see a "Data Manipulation" Action

Re: Date to string transform in flow designer

Ankur Bawiskar — Tue, 25 Feb 2025 04:29:18 GMT

@marclindsay

why not change it to string type then as input?

try to use custom action and use script to convert

If my response helped please mark it correct and close the thread so that it benefits future readers.

Re: Date to string transform in flow designer

Ankur Bawiskar — Tue, 25 Feb 2025 05:25:34 GMT

@marclindsay

check if this helps

Error in Flow using date to string transform function

If my response helped please mark it correct and close the thread so that it benefits future readers.

Re: Date to string transform in flow designer

DeependraS — Tue, 25 Feb 2025 05:46:12 GMT

1️⃣ Open Your Flow:

Navigate to Flow Designer (/flow_designer.do)

Open your existing Flow or create a new one

2️⃣ Add an Action:

Click on "Add Action" (+ icon)

In the "Action" search bar, type: "Format Date"

Select "Format Date" under Data Manipulation

Re: Date to string transform in flow designer

Ankur Bawiskar — Tue, 25 Feb 2025 06:40:33 GMT

@marclindsay

I am unable to see that option to convert Date to String.

Can you share how did you add that?