>Hi all,
>
>A couple of questions:
>
>1) How can I compare a-date-field of my table whose format is mm/dd/yy
>with a date using SET CENTURY? That is if I set SET CENTURY TO 19 ROLLOVER 80, I have this date format mm/dd/yyyy in my txtBox but internally, in the table I have this(mm/dd/yy).
>2) How can I compare dates without Y2K conflict and take out data ?
>
>Should I set date-field to date format or in character/string mode using DTOS/DTOC/CTOD ?
>
>TIA
VFP is storing your dates with the century. So regular date math should still work. e.g., ldNextDay = DateField + 1, lnDays = Date() - DateField. You just have to make sure that whatever you SET CENTURY TO and ROLLOVER to are appropriate for the data being entered. It should not be necessary to convert between character string and date types.
Mark McCasland
Midlothian, TX USA