Skip to main content

Notifications

Announcements

No record found.

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

Due Date - ER Customer Account Statement - not updating date format

(0) ShareShare
ReportReport
Posted on by 307

Hi 

I'm trying to configure a customer account statement which can be used in multiple LE, with multiple date formats i.e UK and US. 

I have set the over all format to use the user preference and this works for the Date & Time field within the Document Details and the other dates still remain in UK Date. I asked my colleague in US to run the same report and her CAS was produced with US date format apart from one field with is Due Date, this still remains in UK date format:

pastedimage1678292407866v1.png

pastedimage1678292454977v2.png

pastedimage1678292501869v3.png

pastedimage1678292606631v4.png

pastedimage1678292666246v5.png

Can someone advise if there is a bug with field, or if i am missing something. 

thanks 

Hetal 

  • Hetal Gore Profile Picture
    Hetal Gore 307 on at
    RE: Due Date - ER Customer Account Statement - not updating date format

    I have now managed to figure this out.

    The due date is tied to Multiple label - the formula on the statement was:

    IF(

       NOT(model.ReportParameters.PrintPaymentSchedule),

       IF(

           LEN(@.'$MainLine'.MarkForPaymentSchedule) = 0,

           DATEFORMAT(@.'$MainLine'.DueDate, "dd/MM/yyyy"),

           @"GER_LABEL:Multiple"

       ),

       DATEFORMAT(@.'$MainLine'.DueDate, "dd/MM/yyyy")

    )

    I changed to:

    IF(

       NOT(model.ReportParameters.PrintPaymentSchedule),

       IF(

           LEN(@.'$MainLine'.MarkForPaymentSchedule) = 0,

           @.'$MainLine'.DueDate, @.'$MainLine'.DueDate

       ),

       @.'$MainLine'.DueDate)

    The due date is now using the date format which is configure within their Windows setting. When i switched my setting to Date Time (UTC-06:00 Central Time (US & Canada)) and Region to English (United States) and then reloaded the excel it picked up the US date format

    Thank all. :)

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans