gsc
Posts: 7
|
| Posted: 12/13/2011, 5:58 AM |
|
I am trying to find a way to be able to define a certain date as the default value for a SQL parameter...
I tried "1901-01-01", 1901-01-01, '1901-01-01', 1901-01-01 00:00:00, .... but none is working...
I have set the Format for the Variable and for the Parameter, but it doesn't work...
Anyone can help me?
|
 |
 |
andy
Posts: 183
|
| Posted: 12/15/2011, 5:44 AM |
|
Have a look at this article:
forums.yessoftware.com/posts.php?post_id=116957
_________________
Andy
RAD tools for rich UI controls:
http://www.koolphptools.com |
|
|
|
benjohn
Posts: 30
|
| Posted: 12/18/2011, 8:32 AM |
|
hi there gsc,
Good Day!
not sure if dates would go as far as the date you have chosen, try '1947-01-01' or '0000-00-00' i was just thinking along the lines of the valid earliest date on the system you are using this application on which you might need to do a bit of research. hope this helps... all the best!
Pal,
Benjohn
_________________
~=~=~=~=~=~=~=~=~=~=~=
get it done. make it happen.
~=~=~=~=~=~=~=~=~=~=~= |
|
|
|
gsc
Posts: 7
|
| Posted: 12/21/2011, 3:26 AM |
|
solved.
The solution was to put
CCFormatDate(CCParseDate("2001-01-01",array("yyyy","-","mm","-","dd")), array("ShortDate"))
in the Default Value.
(Parameter Format is ShortDate)
Thank you for all the help.
|
|
|
|
|
