Change Date/Time field to Date or Appointment
Importing data from another app. I have some dates which have imported as date & time but there is no time. Rather than have a field show 12 Dec 2021 00:00 can I change it to either a date only field or to just show the date and not the time.
Also, I think I want to change a field with date and time to be an 'appointment' so I can have it in my calendar. Can I do that or how can I show a date/time fiels in my calendar?
Thanks
1 reply
-
Here's the answer.
Create a new 'Date' type field.
Use 'update multiple records' and 'assign calculated vale' to the new 'Date' field.
Add the original 'Date & Time' field to the calculation and continue, confirming the data and then 'execute'.
The old Date and Time field can be deleted if no longer needed, the new Date field only displays the date.
Content aside
- 3 yrs agoLast active
- 1Replies
- 272Views