|
| Iniciado por guest, 24,ene. 2016 08:47 - 7 respuestas |
| |
| | | |
|
| |
| Publicado el 24,enero 2016 - 08:47 |
Hi all,
I am working with Scheduler by programming...Everything working fine except the end date of the scheduler..the end date of the scheduler display appears 1 day before the actual end date..ie if the end date of the appointment in the DB is 25-01-2016 ,then in the scheduler display ,the appointment shows till 24-01-2016....and when modify an appointment directly from the scheduler, if we move the enddate to 10-02-16,the enddate in the DB will be 11-02-16..
I think it is a problem related to Date Time format or something related ..Help Plssss |
| |
| |
| | | |
|
| | |
| |
| Publicado el 24,enero 2016 - 12:11 |
Hi,
Now the first problem solved as i entered a time along with the Dates..ie AM timing along with startdate and PM timing along with enddate..But the second problem is still there
ie if I modify the enddate of the schedulerdisplay to 10-02-16,the enddate in the DB will be 11-02-16.. |
| |
| |
| | | |
|
| | |
| |
| Publicado el 24,enero 2016 - 13:12 |
Hi
Is it windev or webdev ? What version would be nice to know as well.
regards
Allard |
| |
| |
| | | |
|
| | |
| |
| Publicado el 24,enero 2016 - 13:30 |
| |
| |
| | | |
|
| | |
| |
| Publicado el 24,enero 2016 - 14:33 |
Hi all,
I just came across the sample provided by Windev..
In the example provided by windev "WD Scheduler" they assume the work start on 8am..so if we modify the enddate of the scheduler to a particular date(15-02-16), the end date in the db will be the nextday 8AM(16-02-16 0800000)..and on redisplaying it in the scheduler, as the appontmnt finishes @ 8am ,the enddate will be one day shorter than the actual date in the db(15-02-16)..so scheduler display works fine..but the enddate in the db is not the actual enddate..it wil be l day more than the actual enddate in the display..
I need actual enddate to be stored in the DB..ie if we changed the enddate in the display to 15-02-16 then in DB also shud b the same..not 16-02-16
is dere any solution?? |
| |
| |
| | | |
|
| | |
| |
| Publicado el 24,enero 2016 - 14:37 |
Hi Amal,
I also use the scheduler and have no problems with actual dates. Make sure you add the right time to the start- and enddate. Start- and enddate are in fact date-time fields. |
| |
| |
| | | |
|
| | |
| |
| Publicado el 25,enero 2016 - 08:44 |
Hi..
Thanks all for ur replies..
At last managed to solve the problem by adjusting the datetime format...I declared the enddate time as "1200000",,so the enddate in the Db falls correctly on the modified date..
 |
| |
| |
| | | |
|
| | |
| |
| Publicado el 25,enero 2016 - 12:25 |
Hello All
While we are on the subject, do you print it. I have tried to use it but if I print it and have more then one thing in a day they print on top of each other. This makes it useless and gave up.
DW |
| |
| |
| | | |
|
| | | | |
| | |
|