day Error?

Asked by enrico
18 years ago.

Hi Dan,

I have daypilot lite.

I have this problem :

if i have an Appointment in 15/01/2008 i see it in 13/01/08 .

maybe it's my mistake but i can't risolve it
Hope this helps

Comment posted by Dan Letecky
18 years ago.

I would guess you store the date and time in separate fields in the database and you supply just the time part as DataStartField. In such a case it adds 'today' as the date part. Please check the DB fields and let me know if that wasn't the problem.

Comment posted by enrico
18 years ago.

this is my sql select :

SELECT DcDocCommLav.ID AS Codice,DcDocCommLav.Data + DcDocCommLav.TimeBegin AS DataInizio, DcDocCommLav.Data + DcDocCommLav.TimeEnd AS DataFine .............

DataEndField = DataFine

DataStartField=DataInizio

i use sqlDatasource

Comment posted by Dan Letecky
18 years ago.

I would make sure that the SQL produces what you expect. Are you able to check the data source (e.g. by rendering it in a plain GridView next to DayPilot)?

This question is more than 1 month old and has been closed. Please create a new question if you have anything to add.