Help

Problem with concatenate and DATETIME_PARSE

Topic Labels: Dates & Timezones
Solved
Jump to Solution
925 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Jon_Stephenson
7 - App Architect
7 - App Architect

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

Accepted Solutions
Ben_Young1
11 - Venus
11 - Venus

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:

Ben_Young1_0-1677274069396.png

Ben_Young1_2-1677274113845.png

Here it is with European formatting:

Ben_Young1_3-1677274146047.png

Ben_Young1_1-1677274089510.png

 

See Solution in Thread

2 Replies 2
Ben_Young1
11 - Venus
11 - Venus

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:

Ben_Young1_0-1677274069396.png

Ben_Young1_2-1677274113845.png

Here it is with European formatting:

Ben_Young1_3-1677274146047.png

Ben_Young1_1-1677274089510.png

 

Ben, many thanks - worked a treat!