{} should work.

>Hi Gang!
>
>Well, we are taking the BIG plunge here.... from VFP 8.0 SP1 to VFP 9.0 SP2.
>
>When I compiled the project, I got some new errors... having to do with this date/datetime evaluated to an invlalid value error....
>
>for example....
>
>

>Compiling c:\pharmacy\class libraries\forms\forms_rx.vcx
>
>INSERT INTO csrHistory (Current,Rx_no, Refill_no, DateFilled, NDC, Name, QtyFilled, Price, Discount, Cash,  ThirdParty, AWP, QtyAWP, Acq, QtyAcq, FMAC, QtyFMAC,PriceCode,InsName,Margin) VALUES (.T.,0, 0, {00/00/0000}, drug.ndc, ALLTRIM(drug.name),This.Parent.DrugPage.pgfDrug.TradePage.txtQtyFilled.value,  This.txtGrossBilled.value, This.txtDiscount.value, This.txtNetBilled.value , 0.00 , drug.awp,  This.txtQtyAWP.value, drug.acquisition_cost, This.txtQtyAcq.value, drug.fmac, This.txtQtyFMAC.value,  Thisform.p_PriceCode,lcInsuranceName,lnMargin )
>
>Error in line 270 of frmrx.pgfScreen.RapidPage.pgfData.PricingPage.Activate (record 4): Date/datetime evaluated to an invalid value.
>
>

>
>I see that it is not liking the {00/00/0000} value.....
>
>So what should I replace this with?......
>
>CTOD('00/00/0000') or perhaps.... {} ?? What would you recommend ????
>
>thanks!!!!