Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Claire Cotton]

Help please!
I have converted dates to UK/European format (DD/MM/YYYY), which is working fine.
I have a problem however when trying to calculate a column where it changes the format to US (MM/DD/YYYY). The calculated column is:

PERIOD = (‘table1′[START_DATE]) &“-“& (‘table1′[FINAL_ENDDATE])

File settings are UK English format.

Has anyone else had this issue?

——————————
Claire Cotton
Data Manager
——————————

[Vilmar Santos]

Não sei se entendi, mas veja se ajuda.

PERIOD =
FORMAT ( [START_DATE], "dd/mm/yyyy" ) & "-"
    & FORMAT ( [FINAL_ENDDATE], "dd/mm/yyyy" )?

——————————
Vilmar Santos
——————————
——————————————-

[Claire Cotton]

Thank you Vilmar, this worked!

——————————
Claire Cotton
Data Manager
——————————
——————————————-

[Adam Artur Boltryk]

Hi Claire,

     ‘Has anyone else had this issue?’

American format date is my nightmare 🙂

Regards,

——————————
Adam Artur Boltryk
Business Analyst
——————————
——————————————-