Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Answered

Cannot fix Time Format for Due Date - Electronic Reporting

(3) ShareShare
ReportReport
Posted on by 58
I am using the Reconciliation Model with the Statement Excel Format.
 
In the provided excel format, the Due Date formatting is set to MM/DD/YYYY but the output when running the statement is showing DD/MM/YYYY 
 
The excel cell for the Invoice Date is also formatted to MM/DD/YYYY but it does output correctly to MM/DD/YYYY- 
 
 
 
 
To no avail. I am at a loss
 
 
Categories:
  • Suggested answer
    Cannot fix Time Format for Due Date - Electronic Reporting
    There is actually a calculated field that will override everything. For those experiencing a similar issue, I suggest searching what cell you're having an issue with ("Due" in my instance) in the format mapping. This is where I found Cell<Statement_Multiple_Label> = IF(NOT(model.ReportParameters.PrintPaymentSchedule), IF(LEN(@.MarkForPaymentSchedule)=0, DATEFORMAT(@.DueDate, "dd/MM/yyyy"), "Multiple"), DATEFORMAT(@.DueDate, "dd/MM/yyyy"))
     
    changed that to MM/dd/YYYY and it worked. 
     
     
    ​​​​​​​
  • Verified answer
    Mohamed Amine Mahmoudi Profile Picture
    Mohamed Amine Mahmoudi 13,896 Super User 2025 Season 1 on at
    Cannot fix Time Format for Due Date - Electronic Reporting
     
    Be careful with uppercase in date format !
     
    You need use MM/dd/yyyy instead of MM/DD/YYYY.
     
    Best regards,
    Mohamed Amine MAHMOUDI

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,074 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,900 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans