+9Can 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!.
Best answer by Ben_Young1
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:
+22Hey @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:
+9Hey @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!
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.