>i cannot use this way. because i have a invoice table in foxpro. each time that a user save an invoice , i save it in the foxpro and i make a copy in my sql server table with a insert or an update ( i dont transfert all fields ) . In my vfp table i have a record name Voided_dte ( a date ) but it always empty except if the invoice is voided. So 98 % of the time this record is empty. So when i do the update or insert it put 01/01/1901 in my sql server. How can i put null or something else
Use EMPTY() function inside your tranlation of values:
<<IIF(EMPTY(yourdateval),null,yourdateval)>>