Skip to main content
Solved

DATETIME_PARSE operating incorrectly


Cody_Winchester
Forum|alt.badge.img+12

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?

Best answer by Arthur_Tutt

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

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

View original
This topic has been closed for replies.

2 replies

Arthur_Tutt
Forum|alt.badge.img+19

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

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


Cody_Winchester
Forum|alt.badge.img+12

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

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


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