Hi.
Just started working with BO and finding it very difficult :(
I created a report that includes a column called Started date /Time.
this column is formed of 2 different part
=Concatenation([Posn Allocation Start Date:Roster];" "+[Posn Allocation Start Time:Roster])

So it shows like 09/25/23 09:00 when i view the report in BO.
as you can see type shows as Text.
and when i export to excel, it shows as text, so i need to go and re format the column with a little formula.
i don't want to have to do that every time this report is generated.
Is there a way to modify that please?