so we continue with our planned approach - Step 1
goal: on create of appointment object disassemble the StartTime MM/DD/YYYY HH:mm a into 2 attributes DATE and TIME
allowing us to let users build there Appointment Date & Time in 2 clicks
Date is easy as we can use DATE_PART , however the outcome is that the inbuild "real" timestamp is DD/MM/YYYY
Time is not so easy as there is no TIME_PART, so we copy StartTime, and
then CHARS_FROM_RIGHT into another attribute. Then are to create a HH:mm from the CHARS_FROM_RIGHT back into a time attribute.
does anyone have an ideas on better approach's or designs?
thanks, nina 🙂