Striping time from an appointment field.
I am entering a date & time appointment so it shows up in the calendar. Can I create another field where I strip the time so I just get the dates for a report?
5 replies
-
Will the following work for you?
you create two field
1. date/time field
2. date field
in the date time field you enter the date and time and you make following code in the "trigger after update" this is also done in the date/time field
Date := 'Date / Time'
This way the date field will automatically be populated when you change the data and time in the date/time field
-
-
Thank you, Frank, but I just get a nonsense date in the new Date field. I tried putting a trigger in the 'Date / Time' field to give me today() in the new Date field. However, that may be good for recording when the record is created, but the reservation may be for the following year. Still need help, but thanks for trying, Frank.
-
Hi David
Create a formula field to hold your date with this as its formula
date(year('Date / Time'),month('Date / Time'),day('Date / Time'))
Regards John
-
Thank you, John. Your code worked perfectly!
Content aside
- 3 yrs agoLast active
- 5Replies
- 259Views