Forum Discussion
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 pulls it in by showing: Tuesday, Septemeber 22, 2020, Which is really annoying because I just want the date (not day of the week) and it's very hard to sort through. I went into transfrom data, and I can see where I can ensure that my data type is set to "date" but that does not resolve my issue. How do I fix/modify the date format?
Another date field pulls in the data by year and quater, which I kind of like, but I don't see where I have control over this formatting.
Thanks,
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,
4 Replies
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)) )Hi,
This does not really address my issue. I need to know how to transform Tuesday, Septemeber 22, 2020 into 09/22/2020.
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,
