Extracting "Date Only" gives new column with a previous date

[Anonymous]

This is odd. I'm extracting Date Only to get a new column with just that, but it changes the dates, if time was midnight (00:00:00)
How to fix this ?
 

[v-yingjl · Accepted solution]

Hi @Anonymous ,

Looks like the regional format of your PC is United Kindom to show the datetime in Power BI, but I cannot reproduce it in my side when changing to the same region(Mar 2022 version in windows 10/11)

Perhaps you can consider providing more details about this issue like the Desktop version, the OS version etc.

In addition, you can try to change the region to US in Windows settings to check whether it issue still happens.

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

That's exactly it. Thanks !

[Vijay_A_Verma]

Need the file containing few rows to look into this. Please upload the file without confidential/sensitive data to a cloud storage service such as Onedrive/Google Drive/Dropbox/Box (Onedrive preferred) and share the link here.