General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>Hi Body
>>
>>I make a parameters view on a date field. when i define the variable before i use the view all work fine but when i let popup the dialog box who ask value of the variable it always give me bad date format.
>>
>>Do you know what i suppose to type to specify a date format?
>>
>>_____________________________________________________________
>>
>>CREATE SQL VIEW "TOTO" ;
>> AS SELECT Nofacture ;
>> FROM mp_data!Test ;
>> WHERE DateDu <= ?pdvDate1
>>____________________________________________________________
>>
>>Thank's in Advance
>>Rock
>
>DId you try typeing the date in Curly Braces? {01/01/99}.. if you have stricdate set to 2 or 3 you will (may) need to use strict date {^1999-01-01}
>
>BOb
Hi Bob
If i set SET STRICTDATE to 0 {1999-01-01} work fine
But if I set STRICTDATE to 1 {^1999-01-01} give me Strict Date Error.
Do you Have another thing to try ?
Rock
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