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

Fabrico's avatar
Fabrico
Frequent Visitor
2 years ago

This solved the problem, thanks for your efforts!