Concatenating date and text fields into one date/time field

  • 0
  • 1
  • Question
  • Updated 3 weeks ago
  • Answered
I am trying to concatenate four fields into one date/time field but struggling with the general syntax.

I have a [start date] field which is a date field, i have an [hour] field which is text with options 1-12, a [minute] field with options :00, :15, :30, :45, and an [ampm] text field with options for AM/PM. 

Any idea how to combine these four fields into one date/time formula field??
Photo of Niraj Shah

Niraj Shah

  • 240 Points 100 badge 2x thumb

Posted 3 weeks ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 57,418 Points 50k badge 2x thumb
Try this

var TimeOfDay Time = ToTimeOfDay([hour] & [minute] & " " & [ampm]);

ToTimeStamp([start date], $Time)
Photo of Niraj Shah

Niraj Shah

  • 240 Points 100 badge 2x thumb
Thank you so much! I had it over complicated but this makes it so simple.