Help

DATETIME_PARSE operating incorrectly

Topic Labels: Formulas
Solved
Jump to Solution
831 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Cody_Winchester
6 - Interface Innovator
6 - Interface Innovator

Hello,

I've encountered an issue with the DATETIME_PARSE function not correctly converting a concatenated date and time from two fields. Is there something I'm missing?

Results render time incorrectly.Results render time incorrectly.Datetime formula with a nested concatenation of two input fields)Datetime formula with a nested concatenation of two input fields)Formatting options do not have any effect on delivering desired results.Formatting options do not have any effect on delivering desired results.

1 Solution

Accepted Solutions
Arthur_Tutt
8 - Airtable Astronomer
8 - Airtable Astronomer

Hey @Cody_Winchester ! Very close but instead of parse, try using DATEADD:

DATEADD({Date}, {Start Time}, 'seconds')

Screenshot 2023-10-30 184224.pngScreenshot 2023-10-30 184203.png

See Solution in Thread

2 Replies 2
Arthur_Tutt
8 - Airtable Astronomer
8 - Airtable Astronomer

Hey @Cody_Winchester ! Very close but instead of parse, try using DATEADD:

DATEADD({Date}, {Start Time}, 'seconds')

Screenshot 2023-10-30 184224.pngScreenshot 2023-10-30 184203.png

Brilliant! Thanks so much @Arthur_Tutt. I was deep down the rabbit hole. I appreciate it!