General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>Can someone give me the proper way to input a date into the built in dialog box that prompts for input when trying to browse a view in design mode? I have tried various combos like {^2002-01-01} or CTOD("01/01/2001") etc. and all I get are operator/operand mismatches and ambiguous date complaints no matter what I try. If I set my input variable from the Command Window with any of the above forms it flies like a champ. What does this dialog box want? Thanks.
>
>Jim,
>Combos ? If so dtoc() since combo values are always char type.
>If combos mean combinations < g > then make sure your parameter is date type. {^2000/1/1} would work).
>Cetin
Hi Cetin,
Yes, I meant combinations. From my comments above, I have tried the {^2001-1-1} format and I get the "Ambiguous date/datetime constant" error. That is what is driving me crazy! {^2001-01-01} or {^2001/01/01} or any other variant I can think of gives me the same error. What am I missing here?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only