1. Use Format Date Time action with Invariant Culture override
In PAD, use the Format Date Time action (instead of Convert to Text)
Set the culture to Invariant (en-US) or "en-US" under advanced options
Choose custom pattern: yyyy-MM-dd'T'HH:mm:ss'Z'
This forces colon-based output irrespective of system locale.
If the built‑in Format action doesn’t expose culture, you can:
2. Use Run .NET Script action (C# or PowerShell)
Insert a small .NET script to format the DateTime in invariant culture.
Example C# snippet:
DateTime dt = DateTime.Parse("%YourDatetimeVariable%");
string iso = dt.ToString("yyyy-MM-dd'T'HH:mm:ss'Z'", CultureInfo.InvariantCulture);
return iso;
Capture the iso string and pass it to your connector.
If I have answered your question, please mark it as the preferred solution ✅ . If you like my response, please give it a Thumbs Up 👍.
Regards,
Riyaz
