Dates

[SP76]

Hi,

I want to be able to show dates which are previous and up to say April 09, what formula do I need to use?

I am able to select a month by using "Like[Enter Month]" but I want to also show all previous months that are due...

 

[JohnB]

Are your dates in a date field? Assuming they are you could use <= 01/04/09 in the criteria in the query. this will show anything earlier then 00:00 hrs on the first of April 2009.

 

[SP76]

Are your dates in a date field? Assuming they are you could use <= 01/04/09 in the criteria in the query. this will show anything earlier then 00:00 hrs on the first of April 2009.

Yes they are in a date field, how can I set it up so as the user can add this info in the "Enter Paramater Value" in the report?

 

[wiklendt]

Yes they are in a date field, how can I set it up so as the user can add this info in the "Enter Paramater Value" in the report?

in your query design grid (edit: that your report is based on), try this in the date field:

<=[Please enter a date]

alternatively, if you don't want that to happen every time you open that report, you can make a form with a text box where your user enters the date they want, then change the [Please enter a date] part to Forms!frmYourForm.txtYourDateControl and then put a button on your form to open your report with that filter, rather than in the query itself.

 

[SP76]

Hi,

I have used the:
Code:
<=[Please enter a date] in the Query Criteria field
and then added: <= 01/04/09 in "Enter Paramter Value"

Message says "Expression is typed incorrectly or it is too complec to be evaluated"

 

[JohnB]

Try putting <=[Please enter a date] on its own this will work You might suggest a format too ie. <=[Please enter a date. dd/mm/yy]

 

[wiklendt]

Hi,

I have used the:
Code:
<=[Please enter a date] in the Query Criteria field
and then added: <= 01/04/09 in "Enter Paramter Value"

Message says "Expression is typed incorrectly or it is too complec to be evaluated"

you need to type only the date in the prompt, since the query criteria already has the "<=" part in it. (i.e., type in 01/04/09, not <=01/04/09)

if you want more options than just "less than or equal to" you'll have to look at what it is you want exactly then figure out (with help if need be!) how to achieve that.

as it is, we're working on "less than or equal to a particular date".

 

[Simon_MT]

I became so annoyed with dates so I thought I would intercept all date requests with a Sales Dialogue Form and hooked all the reports into this form thus:

Between [Forms]![Sales Dialogue Reports]![Start] And [Forms]![Sales Dialogue Reports]![End]

Date problem solved! I'm not usre that is entirely the ideal approach but it works as I couldn't really understand why dates were so difficult!

Simon

 

[wiklendt]

I became so annoyed with dates so I thought I would intercept all date requests with a Sales Dialogue Form and hooked all the reports into this form thus:

Between [Forms]![Sales Dialogue Reports]![Start] And [Forms]![Sales Dialogue Reports]![End]

Date problem solved! I'm not usre that is entirely the ideal approach but it works as I couldn't really understand why dates were so difficult!

Simon

that's the second option i gave you in my post (#4)