Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Replace date field with blank

Status
Not open for further replies.

SMCmtg

Programmer
Mar 27, 2000
90
US
Help anyone? fieldname is emplydatefrom, type is date, width is 8. I get a data type mismatch error. . .

Replace a1.emplydatefrom with str(00/00/0000)

What I am trying to do is blank or clear the field
THX
Bill
 
[tt]Replace a1.emplydatefrom with { / / }[/tt]

Note the use of curly braces (a.k.a. "Hitchcock looking left, Hitchcock looking right").

Robert Bradley

 
or you can use
replace xxx with ctod(" / / ")
or
replace xxx with {}


David W. Grewe
Dave@internationalbid.com
ICQ VFP ActiveList #46145644
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top