Access Form To Query by Date Range

[tyger0951]

I'm using a form to put criteria into a query. I'm using date ranged but if i input date range

<code style="margin: 0px; padding: 1px 5px; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; white-space: pre-wrap; background-color: rgb(238, 238, 238);">03/07 - 03/13</code>

it returns

<code style="margin: 0px; padding: 1px 5px; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; white-space: pre-wrap; background-color: rgb(238, 238, 238);">03/02 , 03/03 , 03/04, 03/05 , 03/06 , 03/07 , and 03/13</code>

instead of the correct results. I've tried changing the format Type from

<code style="margin: 0px; padding: 1px 5px; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; white-space: pre-wrap; background-color: rgb(238, 238, 238);">Medium Date</code>

and

<code style="margin: 0px; padding: 1px 5px; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; white-space: pre-wrap; background-color: rgb(238, 238, 238);">Short Date</code>[FONT=Consolas]

[/FONT] having the form and query match on formats.With no luck. Can anyone help me figure this out ?

[/URL][/IMG]

[/URL][/IMG]

[/URL][/IMG]

 

[xenou]

03/07 - 03/13

This is not the way to input a date range. It can be interpreted as text or a mathematical expression (3 divided by 7 minus 3 divided by 13). You really need to have two input fields: START_DATE and END_DATE. Then you can write a proper query, assuming you have proper data types (DATETIME datatypes).

Short date/Medium date is only about formatting. It has nothing to do with the underlying, or stored values. The underlying values should be true dates, and as such are decimal numbers pure and simple.

 

[tyger0951]

sorry had been inputting 03/7/2015 and 03/13/2015. I got it to work by using Datevalue() and switch to >= and <= instead of betwee.

 

[xenou]

I got it to work by using Datevalue() and switch to >= and <= instead of between

Welcome to the dark side.