Page 1 of 1

How to format a copied date entry

Posted: 25 Apr 2024, 06:41
by wrapt inc
Hi all,

This is probably basic stuff, but I'm no database expert :? . I am trying to copy a date field to a regular input field, however, the copied data is not in date format. ie i believe it is copying the data in seconds, (im not 100% sure on this though).

I need to copy this data, in date field
date/time fields (source)
date/time fields (source)
Screenshot 2024-04-25 123632.png (3.22 KiB) Viewed 98 times
to an input field
input field (destination)
input field (destination)
Screenshot 2024-04-25 123742.png (1.79 KiB) Viewed 98 times
My current automation references the date/time cell ie. [2065]. see below
automation value
automation value
Is there a way to format this reference field so it shows in H:i format?

Re: How to format a copied date entry

Posted: 25 Apr 2024, 17:37
by support
No, there is no way. You can't copy value to different field type.

Re: How to format a copied date entry

Posted: 26 Apr 2024, 04:36
by wrapt inc
Ok. I'll redesign the database to suit my export needs.

Thank you