Recording time in a hidden field

I am having a real issue trying to record the time in a field in a form. Preferably as a hidden field

I have added the date and time component

I have tried every format in the table I can think of date datetime timestamp time and also text

I have given the field on the form a dymanic value of the Var1.datetime and also tried to format it to just the time (which shows in the field correctly)

I have tried addingas a text field and converting

I have tried to change the field to a datepicker and also timepicker using the checkbox

Everything I try just adds the date and not the time to the database 2020-04-06 or 2020-04-06 00:00:00

Please Help I really do not know what to do

Community Page
Last updated: