Forum Discussion
Solved
Transforming Data - Date Format Issue
Hi, I have a report with several date fields that pulls in as: mm/dd/yyyy. When I pulled in my data, one of the date fields pulls in the data in my report a little different than the rest. It pul...
In Data View, select the column header and you will see the ribbon change to 'Column Tools'.
There is a Format dropdown in the ribbon where you select the one you want
I just figured it out.
The solution is once you select the field you want to add into your report, there is a new menu option called "Column tools" that appears at the top where you can control the format of the date.
Thanks,
RickOShay , Before importing make sure your system format is also mm/dd/yyyy
refer
or you have convert using
DD/MM/YYYY to MM/DD/YYYY
date(( right(DD__MM__YY[date],4)), (mid(DD__MM__YY[date],4,2)) ,(left(DD__MM__YY[date],2)))
MM/DD/YYYY to DD/MM/YYYY
date(( right(DD__MM__YY[date],4)), (left(DD__MM__YY[date],2)),(mid(DD__MM__YY[Version_Id],4,2)) )