Date Column formatting

[former_member1187605]

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?

[former_member1187605]

Thank you Noel.

I ended up using a different field.

I think the problem was that the data was a concatenation of a date column and a Time column, so when i tried formatting (as suggested above) it kept giving me an error.

thanks for your quick response

[nscheaffer]

What exactly are you doing when you are reformatting it? What do you want the result to be? I am assuming you want to format this value as a date. To do so, you must convert that text value to a date using the ToDate() function.

Now you can format the value however you want. That should export to Excel how you want it to.

Noel