General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Parameterized View dialog problem
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.
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