0

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

null
    • Frank.1
    • 2 yrs ago
    • Reported - view

    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

    • Frank.1
    • 2 yrs ago
    • Reported - view
    • daviddilworth
    • 2 yrs ago
    • Reported - view

    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. 

    • John_Halls
    • 2 yrs ago
    • Reported - view

    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

    • daviddilworth
    • 2 yrs ago
    • Reported - view

    Thank you, John. Your code worked perfectly!

Login to reply

Content aside

  • 2 yrs agoLast active
  • 5Replies
  • 252Views