Calendar - Time Question

itdeptcorp

Hello,

I am not sure if anyone else is trying to solve the same issues however we would like to know what of these issues are possible to solve.

1) Calendar - Time separate from Date

When creating a new event we would like to find a way to separate the Time element from Date so that it is easier to change Start/End Times.

2) Time (AM/PM) verse Military

The majority of our users are in North America and have a significant challenge using Military time. Is there a solution to also solve this?

If significant modifications must be made please advise and perhaps other
Aware ISV's will support/contribute.

tford

I am interested in these 2 questions / features also.

bartthefish

These features would interest me greatly as well

technopak

Hi,

It sounds as if the question is asking for a solution from Aware and I don't think there is a built-in solution.

What I did to get over the time issue was I created a rule which constructs a Timestamp attribute dynamically from two other fields (a text attribute representing the time, and a date attribute). The rule uses the various date functions to convert the date into individual numeric values representing the day, week, and year respectively. It then splits the text time attribute into two parts to represent the hour and the minute. Then the rule combines the whole lot using the AS_TIMESTAMP function to create the timestamp of the time and date attributes.

My code goes like this -

Object.StartTime=Timestamp(DAY_OF_MONTH(Object.StartTimeDate),MONTH(Object.StartTimeDate),YEAR(Object.StartTimeDate),AS_NUMBER(CHARS_FROM_LEFT(Object.StartTimeTime,2)),AS_NUMBER(CHARS_FROM_RIGHT(Object.StartTimeTime,2)))

The Object StartTimeDate is a date attribute, and the StartTimeTime is a text attribute restricted to values between 00:00 and 23:59.

I don't see too much problem with doing something similar with the AM/PM stuff.

Hope this helps,

Peter

thom

While technopak's workaround is great - it is after all a work-around for something that Aware should really address. The time data type is part of the SQL92 standards (apart from both date and datetime data types) and should be supportable by most of the databases.

There are plenty of implementations of time pickers in EXTJS and GWT to have at least a simple one and the time data type included. If I had the time and/or experience I would gladly help out here.... so I hate to push Aware on things like this because there are work arounds.

I know there is a Wish List section of the forum, but it seems to be less active then the other areas. It would be great to see this funcitonality included sooner rather than later.

aware_support

Could you please explain in more detail what you would like to have in the ideal world?

Also I am not sure I understand the second question at all - what exactly is a military format? If it is a AM/PM format, have you tried the corresponding Timestamp format (there is one, I don't remember it off the top of my head)?

tford

I'll address this part:

2) Time (AM/PM) verse Military

I changed the format of both StartTime and EndTime attributes of an Appointment BO to format: M/d/yy h:mm a

Results were very good.

However, on the left time bar of both the Daily view and Weekly view still have times of:

13:00 am
14:00 pm
etc

instead of:
1:00 am
2:00 am
etc

tford

Oops -- should have been:

13:00 pm
14:00 pm
etc

instead of:
1:00 pm
2:00 pm
etc

tford

1) Calendar - Time separate from Date

When creating a new event we would like to find a way to separate the Time element from Date so that it is easier to change Start/End Times

Screen shot of how Google Calendar handles it:

It's very easy to use.

technopak

Hi,

Assuming Aware doesn't handle the AM/PM thing, why not just create an ObectTime attribute of type text with choices 12.30am, 1.00am, 1.30am, 2.00am etc etc

Then use dynamic rules to construct the timestamp which Aware wants from the Date and the converted values of the ObjectTime attribute.

A couple of dynamic rules should easily achieve the same functionality as Google offers.

It's just a workaround, but not a big problem 🙂

Peter

itdeptcorp

I wanted to point out that there is an Add-On when integrated should resolve this issue for all of the Aware customers.

Aware has quoted an amount to integrate this -

As mentioned in this link - We would contribute towards this solution

NBDAB

Does anyone know if there is a work Example in any Sample applications?

Regards,
Lars

rocketman

I'm reluctant to part with cash for the time thing because TIME fields are standard within most databases and it's really annoying that AwareIm haven't done anything about this sooner. I'm told in V3 they used to have thumbwheels you coul dspin to select a time ( a la my iPhone) a really backward step taking those out!!.

In My case - I have two fields - a Launched field and a landed field which our flight administrators fill out by clicking a clock icon (we have a touch screen at the launch control vehicle) This is great because the fields - which are timestamps have their output set to hh:mm EXCEPT when - a few days later our supervisor checks the fligh logs, spots a mistake and recitfies the landed time, it then calculates the flight duration as being from the launch time on the day of the flight to the landed time on the day the supervisor checked the logs - the flight was recently costed at £47, 567.80 for a 15 minute flight. That's more expensive than inkjet cartridge ink :lol:

A fully functional, correctly working TIME attribute should be very soon and FREE

NBDAB

any chance you could post your solution? here is ours

We have a BO called AppointmentTime, with two columns Time_Start and Time_End (as Attribute type Time) of HH:mm a

Then we imported a list of all Start times and End times we wish to show in 15 min increments.. i.e. 1:00 am, 1:15 am, 1:30 am, 1:45 am etc...

Then we changed the Appointments default Start and End attributes to be only MM/dd/yyyy

And use this rule to "create" the string

((Appointment.Date_Start IS DEFINED AND Appointment.Time_Start IS DEFINED) OR
Appointment.Date_End IS DEFINED) AND Appointment.Time_End IS DEFINED

Then

Appointment.StartTime=AS_TIMESTAMP(AS_STRING(Appointment.Date_Start,'MM/dd/yyyy')+' '+Appointment.Time_Start,'MM/dd/yyyy HH:mm a')
Appointment.EndTime=AS_TIMESTAMP(AS_STRING(Appointment.Date_End,'MM/dd/yyyy')+' '+Appointment.Time_End,'MM/dd/yyyy HH:mm a')

Is there a better method?

ninap

perhaps based on the new calendar we could also have predefined attributes for the "Appointment" BO for Time & Date?

if this is possible that would be a wonderful simple feature.

result: we can remove additional rules from a bsv

thanks, nina 🙂

ninap

hi,

is it possible to allow for calendar fields as described in the post/thread?

adamgonzalez1984

I am using the method that technopak described but I had a question on how to reverse this process. I want to be able to click on the calendar and have my custom TimeDate and TimeHour fields be populated by the timestamp awareIM generates when you click on a section of a calendar. So if I click on next week on Thursday at 1pm I want that information to be copied over to my timedate and timehour fields so I can present a more intuitive view when creating an event directly from the calendar. anyone have a clue how to get this done?

corradomatt

@[deleted] - I'm looking for this functionality as well. I have tried a few things to make this work (although right now I can't think of what they were) with no luck.

I would love it if I could make the calendar look, feel and act much like google calendar does currently. It is very well designed and the functionality makes managing multiple appointments a breeze.

Makeing the awareim calendar work more like that would be incredible!

adamgonzalez1984

If Event.StartTimeAMPM='PM' AND Event.StartTimeTime IN '01:00', '01:30', '02:00', '02:30', '03:00', '03:30', '04:00', '04:30', '05:00', '05:30', '06:00', '06:30', '07:00', '07:30', '08:00', '08:30', '09:00', '09:30', '10:00', '10:30', '11:00', '11:30' Then 
Event.StartTime=Timestamp(DAY_OF_MONTH(Event.StartTimeDate),MONTH(Event.StartTimeDate),YEAR(Event.StartTimeDate),AS_NUMBER(CHARS_FROM_LEFT(Event.StartTimeTime,2))+12,AS_NUMBER(CHARS_FROM_RIGHT(Event.StartTimeTime,2)))

If Event.StartTimeAMPM='AM' AND Event.StartTimeTime IN '12:00', '12:30' Then 
Event.StartTime=Timestamp(DAY_OF_MONTH(Event.StartTimeDate),MONTH(Event.StartTimeDate),YEAR(Event.StartTimeDate),AS_NUMBER(CHARS_FROM_LEFT(Event.StartTimeTime,2)),AS_NUMBER(CHARS_FROM_RIGHT(Event.StartTimeTime,2)))

To handle the setting of AM PM here's what I did. I followed technopak's advice and I also created 2 extra fields. StartTimeAMPM, EndTimeAMPM with both only having AM or PM as a choice. I then added the code above to the business objects rules to set the start time. To set the end time just substitute end time for start time in the rule. You also have to create a separate rule for the 12:00 and 12:30 time slot.

ninap

is anyone interested in donating towards a Real solution for this issue? I would be interested also.

we, and other users have surgically dissected this so that the end result is doable but we loose the build in functionality of drag-n-drop & create on click events features of the EXT Cal. Pro..

users have to do

choose start date
choose start time
choose am or pm

choose end date
choose end time
choose end am or pm

then the rules begin to process and have to recalc, reverse engineer the StartTime and EndTime's so to achieve what could be inbuilt.

StartTime Timestamp = MM/dd/yyyy HH:mm a