Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Problem with concatenate and DATETIME_PARSE

Topic Labels: Dates & Timezones
Solved
Jump to Solution
1535 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!