Forum Discussion

Fab117's avatar
Fab117
Helper IV
3 years ago
Solved

Date are automatically split in year/Quarter/Month/Day

Hi,

I'm using table with dates [TaskFinishDate]. View in Transform Data mode:

 

In Desktop, I can see that [TaskFinishDate] is split in "Year", "Quarter", Month" and "Day":

 

And then, if I use this field in a Table, dates are split:

 

How can I have "standard" dates (in Eu format) in one column: e.g.: "15.12.2023"?

 

Thanks

 

Fab

Need Help
  • mussaenda's avatar
    mussaenda
    3 years ago

    Hi Fab117 ,

     

     

    based on the screenshot, you right click the column of the date,

    the select date instead of Date Hierarchy.

     

    That will solve your issue.

     

    Hope this helps.

     

2 Replies

  • mussaenda's avatar
    mussaenda
    Community Champion
    3 years ago

    Hi Fab117 ,

     

     

    based on the screenshot, you right click the column of the date,

    the select date instead of Date Hierarchy.

     

    That will solve your issue.

     

    Hope this helps.

     

  • Fab117's avatar
    Fab117
    Helper IV
    3 years ago

    Thank you very much.

    Solved.

     

    Have a nice end of the day.

     

    Fab