Forum Discussion

Frequent Visitor

1 year ago

Date Format

How can I make this text format in a dd mm yy format? Using the normal DateValue it seems to give me dates in future eg 7 Dec instead of 11 July?

Frequent Visitor

1 year ago

Thanks, This did not seem to work..I am wondering if it is due to the date formats not being consistent eg days drop the leading zero but months have a leading zero.

PhilipTreacy
Super User
1 year ago
Hi Chippy

No that shouldn't matter - download this file for an example.

When you say it didn't seem to work - why do you say this? What result did you get when you tried what I suggested?

Please provide the actual data you are using - even better would be the file with the data in it.

Regards

Phil
- Chippy
  Frequent Visitor
  1 year ago
  https://froneri365.sharepoint.com/:u:/r/teams/AU_Projects/Dashboards/Controlled%20Docs/Date%20Format%201.pbix?csf=1&web=1&e=vlAmaI
  
  I am not sure if this is the best way to sahre as I can not attach a file..bit in this sample you can see the original dates when converted to datevalue reverses some dates from dd mm to mm dd
  - PhilipTreacy
    Super User
    1 year ago
    Hi Chippy
    
    I can't access that, it requires a login to your system.
    
    You can put the file on OneDrive, Google Drive, Dropbox etc and then share the link to it.
    
    Regards
    
    Phil

Related content