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?