AM and PM in Appoitments

itdeptcorp

Does anyone else use AM and PM for Appointment's?

We have a many step set of Rules to calc out the AM and PM in the Object - However we just realized it is unable to calc any of the 12:00 times.

** Just curious if anyone else is doing this?

Thanks

itdeptcorp

typo - Appointments (eyes)

itdeptcorp

if anyone see's a way to solve this please advise;

High-level we manipulate the AIM Calendar required date format, to fit the users requirements, then reverse it back to match input required.

We have PM rules which add +12 to the HH:mm fields IF PM exists

If calc.Time_Start CONTAINS 'PM' Then 
calc.nr_timeStart=AS_TIMESTAMP(calc.Time_End,'HH:mm')+12 ELSE calc.nr_timeStart=AS_TIMESTAMP(calc.Time_End,'hh:mm')

However any time which has 12 in it fails to properly calculate 12:00, 12:30 AM or PM

Tips;
http://stackoverflow.com/questions/9000906/calculate-date-time-difference-in-java-considering-am-pm

Standards;
http://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html

Still cannot get it working - If anyone has any ideas please shoot them at us..

itdeptcorp

PM me if you think you know how to solve and we can send the BSV

we added additional IF statements looking IF Time_Start CONTAINS '12' then -12 , or Time_End etc..
we have adjusted the Attributes for HH:mm, hh:mm in all variations and same result
our Rules also adjusted to match HH:mm or hh:mm same result.

Somehow still cannot resolve 12 Start or End Times

juicer

The 24 hour clock runs from 00:00 (12:00 AM Midnight) to 23:59 (11:59 PM).

Times in 12 hour range are a special case and need a different calculation.

For 12:00 AM thru 12:59 AM you need to subtract 12 giving 00:00 thur 00:59.
For 12:00 PM thru 12:59 PM you do not need to convert, they are already in the 24 hour format.

itdeptcorp

So here is what we have in our Rule Logic;

We solve the Start Time as follows;

If calc.Time_Start CONTAINS 'AM' AND calc.Time_Start CONTAINS '12' THEN
calc.nr_timeStart=AS_TIMESTAMP(calc.Time_Start,'hh:mm')-12 ELSE calc.nr_timeStart=AS_TIMESTAMP(calc.Time_Start,'hh:mm')

If calc.Time_Start CONTAINS 'PM' AND calc.Time_Start CONTAINS '12' THEN
calc.nr_timeStart=AS_TIMESTAMP(calc.Time_Start,'HH:mm')+12 ELSE calc.nr_timeStart=AS_TIMESTAMP(calc.Time_Start,'hh:mm')

We solve the End Time as follows;

If calc.Time_End CONTAINS 'AM' AND calc.Time_End CONTAINS '12' THEN
calc.nr_timeEnd=AS_TIMESTAMP(calc.Time_End,'hh:mm')-12 ELSE calc.nr_timeEnd=AS_TIMESTAMP(calc.Time_End,'HH:mm')

If calc.Time_End CONTAINS 'PM' AND calc.Time_End CONTAINS '12' Then
calc.nr_timeEnd=AS_TIMESTAMP(calc.Time_End,'HH:mm')+12 ELSE calc.nr_timeEnd=AS_TIMESTAMP(calc.Time_End,'HH:mm')

We calc the Total Time as follows;

calc.total=calc.nr_timeEnd-calc.nr_timeStart

itdeptcorp

The input for Start and End times are Text Fields with (drop down) 01:00 AM, 01:15 AM through 12:45 PM

itdeptcorp

ah - solved it - we think (was missing the +12 on IF Start is PM and 12, or IF End is PM and 12