Skip to main content
Solved

DATETIME_PARSE operating incorrectly

  • October 30, 2023
  • 2 replies
  • 35 views

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')

2 replies

Arthur_Tutt
Forum|alt.badge.img+19
  • Brainy
  • Answer
  • October 30, 2023

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!