Problem with concatenate and DATETIME_PARSE

[Jon_Stephenson]

Can anyone see what I am doing wrong here.

Two fields, one date (as text type) one time (as text type) - The formulae field SHOULD make these into a single date/time field - This is the formulae I have, but I get errors on any dates with two characters as the day - I have tried various formatting DD/MM etc with no joy!.

DATETIME_PARSE(CONCATENATE({TU Start Date} & " " & {TU Start Time}))

[Ben_Young1 · Accepted solution]

Hey @Jon_Stephenson! 

Try this formula:

DATETIME_PARSE(
    {TU Start Date} & " " & {TU Start Time},
    "DD/MM/YYYY HH:mm"
)

Here's what it looks like when I tested it:

Here it is with European formatting:

[Jon_Stephenson]

Ben, many thanks - worked a treat!