topic Re: Dynamic Value Date formatting in Pipelines

Dynamic Value Date formatting

Fabrico — Tue, 23 Jan 2024 02:59:28 GMT

I've got an API call that I'm trying make that requires a date format like;

yyyy-MM-ddThh:mm:ss+00:00

For some reason, even though I can get Data Factory to create this as a format, as soon as I try to use it as a dynamic value in a Rest Copy Data additional header the system decides to reformat it as;

yyyy-MM-ddThh:mm:ssZ

And it's no longer accepted by the API I'm calling.

Is there some way to force Data Factory to stop doing this conversion? I've tried using CONCAT, sticking the value into a String Variable, nothing seems to work.

Re: Dynamic Value Date formatting

Anonymous — Wed, 24 Jan 2024 10:00:39 GMT

Hi Fabrico ,

Thanks for using Fabric Community

Can you please try to use the utcNow() function with custom formatting in Fabric Data Factory:

Instead of relying on the pre-formatted date time, you can use the utcNow() function within your expression to generate the current date and time in UTC. Then, use string manipulation functions like substring and concat to format it according to your requirement:

@utcNow('yyyy-MM-ddThh:mm:ss') + '+00:00'

Hope this is helpful. Please let me know incase of further queries.

Re: Dynamic Value Date formatting

Fabrico — Wed, 24 Jan 2024 22:04:20 GMT

Thanks for your reply, I've tried formatting the date in a number of different ways but Fabric/Data Factory seems to be automatically converting it into a Zulu time before passing it to the API.

When I look at the Input criteria after running the Pipeline, here's what's now showing for that value;

If I hardcode a datetime in there it also converts it to Zulu;

If I wrap that hardcoded datetime to change it to a literal string then it works fine.

I've also previously tried wrapping the Dynamic value with literal strings but it always seems to convert the datetime before understanding it's a literal.

I'm struggling to understand why we're given the ability to format the date in the Dynamic Value box if Data Factory is just going to change it to whatever it wants anyway...

Re: Dynamic Value Date formatting

Anonymous — Mon, 29 Jan 2024 08:58:42 GMT

Hi Fabrico ,

Apologies for the issue you have been facing. If its a bug, we will definitely would like to know and properly address it.

Please go ahead and raise a support ticket to reach our support team: support-ticket-link

After creating a Support ticket please provide the ticket number as it would help us to track for more information.

Thank you.

Re: Dynamic Value Date formatting

Anonymous — Tue, 30 Jan 2024 13:41:16 GMT

Hi Fabrico ,

We haven’t heard from you on the last response if you got a chance to create support ticket, please provide the ticket number as it would help us to track for more information.

Re: Dynamic Value Date formatting

HimanshuS-msft — Wed, 31 Jan 2024 22:29:36 GMT

Hello
Let me start with it was a hard nut to crack 🙂 , took me few hours . This is what worked for me .

@formatDateTime(utcnow(),'yyyy-MM-ddTHH:mm:ss zzz')

Output

{ "name": "Change Date format", "value": "2024-01-31T22:26:37 +00:00" }

Hope this helps .

Thanks
Himanshu

Fabrico

Re: Dynamic Value Date formatting

Anonymous — Fri, 02 Feb 2024 07:25:27 GMT

Hello Fabrico ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .
In case if you have any resolution please do share that same with the community as it can be helpful to others .
If you have any question relating to the current thread, please do let us know and we will try out best to help you.
In case if you have any other question on a different issue, we request you to open a new thread .

Re: Dynamic Value Date formatting

Fabrico — Sun, 04 Feb 2024 21:47:31 GMT

This solved the problem, thanks for your efforts!