How can I custom a attribute or metric in Date format?

Hi Lena, 

if you're creating insights via Analytical Designer - all the insights already display the date in the following format: MM/DD/YYYY. More details can found in the below documentation: 
https://help.gooddata.com/doc/en/dashboards-and-insights/analytical-designer/visualize-your-data/create-insights

Alternatively, if you're creating reports via the Report Editor as outlined in the below documentation: 
https://help.gooddata.com/doc/en/dashboards-and-insights/reports/working-with-reports/creating-new-reports-in-the-report-editor
 

You have 2 options to change the display labels: in the report and you have two choices:

1) In table mode, right-click on the date header and select a new "display label" from the menu

2) Otherwise, under "HOW" dialog box in your report, select your date dimension, and in the third column, select the most appropriate "display label". 

Hope this helps! 

Hi Lena, 

my apologies for not initially understanding the issue here - please correct me if I am wrong, the issue here is that your metric returns a number, not the date in this format: mm/dd/yyyy. You can use a custom number formating to change the display in the numeric expression. Please see the following documentation that will help you with this:
https://help.gooddata.com/doc/en/dashboards-and-insights/maql-analytical-query-language/maql-use-cases-and-tutorials/finding-min-and-max-dates-using-date-arithmetic

In the above documentation, we have the following example - you'll need to slightly tweak this for your usecase of: mm/dd/yyyy

SELECT MAX ((SELECT (10000 * MAX(Year (Date))) + (100 * MAX(Month (Date))) + (MAX(Day of Month (Date))) BY <connection point>)) WHERE (SELECT COUNT(Date (Date), <connection point>) BY Year (Date), ALL OTHER) > 0

Hi Michael,

I had the issue which can not use multiple Date dimensions in one Insight, I found that this issue was fixed today, please following this link: Cannot pull multiple Date dimensions into one Insight | The GoodData Community

Currently, there is still another issue, I cannot use this formula: Status DIQ: select THIS - “WO Closed Date”,   because the “WO Closed Date” haven’t included in the Insight.

Example for another formula I can use: Tickets DIQ: select THIS - “Ticket Created Date”, this formula is usable because “Ticket Created Date” column is already included.

Could you please take a look on this? 

Thanks!