Trouble with Parameter fields

[chibbert]

I have a query in an AS400 database which I need to only select data between dates.____Our system uses the century form of dates (January 1, 2009 = 1090101)__If I write the query using invoice date is "in the range" 1090101 and 1090201 - the query works fine__But if I make a parameter field BEGIN and another that is END__then change the filter to invoice date is >= 1090101 and invoice date is <=1090201 it will not accept the date when it calls for the parameter entry. It responds with an asterisk.____I am technically asking for the exact same data either way but one doesn^t work. Is there a work-around on this or am I overlooking something.____Thanks__Chris

[Chris_Hibbert_(Guest)]

It is in the format CYYMMDD (I think this is the default or only method in AS400)____C=Century__YY=2 digit year__MM=2 digit month of year__DD=2 digit day of month______Today^s date 3/2/2009 is displayed as 1090302____Thanks for your help.

[Chris_Hibbert_(Guest)]

Sorry Kathleen - after re-reading you are asking for data-type____It is numeric____Thanks for your continued help.

[kfleming]

What data type is your invoice date field?____Kathleen__R&R Support

[Chris_(Guest)]

Kathleen - that solved it. I had the BEGDATE set up as 7 but only had the ENDDATE set up with 1____Sorry for the trouble but thanks so much for the answer!____Chris

[kfleming]

And your parameter field is numeric with a format of 7 integers no decimals?____Kathleen__R&R Support