Forum Discussion

NirajShah's avatar
NirajShah
Qrew Cadet
7 years ago

Concatenating date and text fields into one date/time field

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 ...
APIs and custom code
Forms
Formulas and functions
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
Try this

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

ToTimeStamp([start date], $Time)