How to format event start/end time using a column as date?

I just need to create a event after a form saving. To do that, I created a action that add a new row to the calendar table.

In Set these columns , I need to define the Start and End columns to contain values taken from another form, I can do that without problems. The value taken from the other form is a date, I need to set a datetime for Start/End columns using that date. To achieve this I tried to create an expression that uses the date column from the first form and manually inserts the time, but the AppSheet doesnโ€™t recognize it as a datetime.

I tried to format:
CONCATENATE([date_form_1], โ€œ 08:00:00โ€)
DATETIME(CONCATENATE([date_form_1], โ€œ 08:00:00โ€))
DATETIME ([date_form_1] & โ€œ 08:00:00โ€)

Only DATETIME([date_form_1]) worked, but I canโ€™t use the default time of noon.

Solved Solved
0 6 231
  • UX
1 ACCEPTED SOLUTION

Please try

DATETIME(CONCATENATE([date_form_1]," ", โ€œ8:00:00โ€))

Please note the space, " " between date and time value concatenation. I believe the Datetime column format needs a space between Date and Time values. Hope this helps.

View solution in original post

6 REPLIES 6
Top Labels in this Space