Removing Data Hierarchy and Just Showing Date (dd/mm/yyyy)

[kamini]

Hi folks,

I have created a date as showing below but I'm unable to get rid of the hierarchy information (Year, QTR, Month, day) and just show the date (dd/mm/yyyy). I can find the track to handle this. The Start Date below shows the right way of showing the date and the previous date is the one I need to format it the same way.

Greatly appreciate your help!

[kamini]

This field (R_Start Date) is a calculated field,

R_Start Date =

IF (

    [Start date] = BLANK (),

   [Creation Date],

    [Start date]

)

[kamini · Accepted solution]

Hi folks, I got my answer, to Uncheck the Data Heirarcy, one should select the actual date and the data hierarchy will be disabled. I selected the R_Start_Date and the check mark got assigned to the R_Start_date instead of the Data Hierarchy. 😀