Appointment BO, add minutes to the EndTime

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
Powerm
Posts: 476
Joined: Mon Feb 01, 2010 9:44 pm

Appointment BO, add minutes to the EndTime

Post by Powerm »

Please advice, how would you :

- Create an Appointment BO where user selects a StartTime
- User selects from a dropdown an attribute ( Medical Treatment ) which may have different types of duration showned in numbers and representing minutes : 15, 30, 45
- have the EndTime calculated like : Appointment.EndTime=Appointment.StartTime + Appointment.TreatmentDuration

I have tried to used MINUTES(Appointment.StartTime) but it does not work...
Independent Developer
Powerm
Posts: 476
Joined: Mon Feb 01, 2010 9:44 pm

Re: Appointment BO, add minutes to the EndTime

Post by Powerm »

Managed to make it work using the TIME_ADD function, sample here :


http://www.awareim.com/forum/viewtopic. ... tes#p33728
Independent Developer
Post Reply