I have a requirement to allow users to enter a date in "dd/MM/yyyy HH:mm:ss" format.
I have below settings for DCode1:
When I see the Register table (backend), I can see the the date is stored with time:
The register (frontend) also shows the time:
but it doesn't allow to enter date with time and give following error: "Value could not be converted".
So my question is: Can we enter a date along with time in a Register? An alternative would be to have a seperate text field for "HH:mm:ss" and convert date and time fields in rule for calculations but it would be good if we can enter both in the same field.
Solved! Go to Solution.
Please check internally what is the datatype for your column.
Select * from Information_schema.columns where table_name = 'XFW_PLP_Register'.
I see only Date type as datatype for some of the columns like HireDate, BirthDate so not sure if these columns are built in to capture the time details as well. I see a Datetime_precision column, pls check if this can be set to capture date and time in the desired format.
Not really sure why you need to capture the timing. Is it for auditing? If so, why not use the Audit logs?
Even though the datatype is DateTime, I don't think the front end shows a time. It just shows a calendar. If you are really truly looking for it, then I would say use the event handler and update the date field to capture the current time and add to the existing value the user chose.