Look this please
the procedure does not show exactly the right reservation
on My archive I have the room n. 7 has a different date range
Why it show other dates ?
I explain You
I have RESERVA->CHECK_IN and RESERVA->CHECK_OUT on reserva.dbf and I must show the reservation
the final user can select the dates fron datepich control , the datepich are on the ribbonbar ( I select from 23.02.2013 to 23.02.2013)
when I show the bitmaps I made a dbseek on number of room to se the state of each room
IF RESERVA->( DbSeek( nRoom ) )
and then
IF DToS( RESERVA->CHECK_OUT ) > DToS( dStart ) .AND. DToS( RESERVA->CHECK_IN ) < DToS( dEnd )
nStato:= val(RESERVA->STATUS)
endif
ELSE
nStato:= 0
ENDIF
I tried also with
IF (DToS( RESERVA->CHECK_IN ) >= DToS( dStart ) .AND. DToS( RESERVA->CHECK_IN ) <= DToS( dEnd ) ) .OR.;
(DToS( RESERVA->CHECK_OUT ) >= DToS( dStart ) .AND. DToS( RESERVA->CHECK_OUT ) <= DToS( dEnd ))
but it make error !!!! ( the same)
