Skip to main content

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

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:

 

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:

 


Ben, many thanks - worked a treat!

Reply


Terms & Conditions