Thanks Viv. That one doesn't work but this one does.

SqlDataSource2.UpdateParameters("DateCompleted").DefaultValue = Now()

>SqlDataSource2.UpdateParameters.Add("DateCompleted", DateTime.Now) ?
>
>>Do you know the syntax for this?
>>

>>SqlDataSource2.UpdateParameters.Add("DateCompleted", Now())
>>

>>
>>>Sorry, in your case you need a record rule. I'll post details a bit later.
>>>
>>>>>>Can someone tell me how to save the current datetime from an aspx page into a VFP database? I am trying
>>>>>>

>>>>>>
>>>>>>asp:Parameter Name="datecompleted" Type="DateTime" DefaultValue='>%=Now()%<' 
>>>>>>
>>>>>>

>>>>>>
>>>>>>but it doesn't work. The error says the string is not recognized as a valid datetime.
>>>>>>
>>>>>>Thanks
>>>>>
>>>>>Just set the parameter in code behind, why do you need it in ASPX?
>>>>>
>>>>>BTW, which database we're talking about? May be you can just set it in the trigger instead?
>>>>
>>>>Its a VFP database, being edited via an aspx formview. If I create an update trigger with something like
>>>>
>>>>

>>>>repl datecompleted with datetime()
>>>>

>>>>wouldn't that create an infinate loop?