Skip to Content
0
Aug 23, 2023 at 08:41 PM

Date Column formatting

72 Views

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])

image.png

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?

Attachments

image.png (31.6 kB)