Combining Dates

[hspenik3]

I have different fields all associated with the same date but for some reason I'm getting multiple lines instead of just showing it under one single day.  How can I fix this?

[Anonymous]

HI @hspenik3,

Can please share some dummy data with a similar data structure and expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[amitchandak]

@hspenik3 , I think your date has a time stamp, and you are not able to see it because of the format.

Change the data type to date/time and choose a format that can show you time

and get a date column like

new Date = [Date].date
or
new Date = date(year([Date]),month([Date]),day([Date]))

[aj1973 · Accepted solution]

Hi @hspenik3 

Use Matrix and put the dates in the Column