Appointment Book

jacklcs

Hi..

Present, the appointment from AwareIM is:
StartTime: {date and time}
EndTime: {date and time}

My Client want to enter the following:
Appointment Date: [Just the date only]
Start Time: (10.00... 10..30.... 2300) - Drop Down
End Time🙁10.00... 10..30.... 2300) - Drop Down
Customer Name: [Drop Down]
Employee Name: (Multiple)

If I create separate attribute for Appointment Date, Start Time, End Time
Will the calender show me the result?

How do i copy the appointment date, start time / appointment date end time to the initial attribute?

welcome for any enquiring...

Many thanks.

jacklcs

i managed to create a "ApptDate" Attribute. After I select the ApptDate, I copy to the StartTime and EndTime. The Calender change. That good.

I have create a "ApptStartTime" and "ApptEndTime" Attribute (drop down).

I have entered ApptStartTime as "09:00"
I have entered ApptStartTime as "10:00"

How do I merge the ApptDate and AppStartTime to StartTime?

11-04-2011 09:00

How do I merge the ApptDate and AppStartTime to EndTime?

11-04-2011 10:00

I check the manual for the function, there is a function called " TIMESTAMP ", i have tried but still cannot merge together..

can anyone help...

jacklcs

Hi
MyDate = TIMESTAMP 11/04/2011 18:45

DateTest.MyDay=DAY_OF_MONTH(DateTest.MyDate) - 11
DateTest.MyMonth=MONTH(DateTest.MyDate) - 4
DateTest.MyYear=YEAR(DateTest.MyDate) - 2011
DateTest.MyHour=HOUR(DateTest.MyDate) - 18
DateTest.MyMinutes=MINUTE(DateTest.MyDate) - 45

How to merger back?

DateTest.MyTimeStamp=AS_TIMESTAMP(DateTest.MyDate,DateTest.MyMonth,DateTest.MyYear,DateTest.MyHour,DateTest.MyMinutes,'dd/MM/yyyy HH:mm')

Show error....
anyone can help?

jacklcs

i have a date and time attribute... how to i merge as TimeStamp?
I have tried TIMESTAMP and AS_TIMESTAMP.. still cannot
DateTest.MyTimeStamp=TIMESTAMP(11,4,2011,11,0) - it worked
DateTest.MyTimeStamp=TIMESTAMP(DateTest.MyDay,DateTest.MyMonth,DateTest.MyYear,DateTest.MyHour,DateTest.MyMinutes) - IT FAIL
what wrong?
I have tried MyData, My Month, MyYear, MyHour, MyMinutes - All at PlainText
I have tried MyData, My Month, MyYear, MyHour, MyMinutes - All at Number
also cannot

my the purpose is that my client do not want to enter the time, they want to drop down the time selection....
i need to copy the date and time to the Appointment Calender StartTime and EndTime in order to show on the Calender.

anyone can help..please

jacklcs

Thanks for technopak.....

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)))

StartTimeDate is a date attribute
StartTimeTime is a text attribute

now the date and time merger become timestamp... cool...

ninap

hi,

how would you solve this if your used "06:00 am" as the StartTimeTime?

would we

1) AS_NUMBER(CHARS_FROM_RIGHT(Object.StartTimeTime,5

2) AS_NUMBER(CHARS_FROM_LEFT(Object.StartTimeTime,5 ?

txs, nina 🙂

ninap

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

This worked for us

txs, nina 🙂