Forum Discussion

Fabrico's avatar
Fabrico
Frequent Visitor
2 years ago
Solved

Dynamic Value Date formatting

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 a...
pipelines
  • HimanshuS-msft's avatar
    HimanshuS-msft
    2 years ago

    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

HimanshuS-msft's avatar
HimanshuS-msft
Microsoft Employee
2 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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 .

  • Fabrico's avatar
    Fabrico
    Frequent Visitor
    2 years ago

    This solved the problem, thanks for your efforts!