Update the date in present month

[krkow]

HI,



I have created the query which selects the "DateCapture" in every month. (I only check the data above <95 %).

My query has a few columns :

Name Country Date DataCapture

When I'm going to check if the data are above 95% in every month

(mostly after completing previous month I check the data are in required range) by typing the date manually e.g 2011-10-01.

Is it possibile to set automatically the date typing?

I thought that the date to my query might be taken from system, but the format must be simillar, meaning yyyy-mm-dd (always 01)

Do you know how it can be set in sql?
BR

kk

[Robeen]

Can you explain a little more clearly what you need your query to do?

Are you just trying to get data for the previous month?

[krkow]

I get the data every month and compare how many of the is completed. ( if the data have 100%.

In my query there is one column with date. In every month I have to put by manually the date for last month. e.g now we have 01-11-2011 and I would like to see the data for 01-10-2011.

[Robeen]

I think what you need to do is create a query with all the fields from your table that you need to see - and then - in the 'Criteria' row for your Date field - put something like this:

 
Between DateSerial(Year(Date()),Month(Date())-1,1) And DateSerial(Year(Date()),Month(Date()),0)

This will give you only records with dates in the previous month.

Let me know if that works.

[krkow]

HI

Yes it works, THANK YOU

[Robeen]

I'm glad I could help!
Mark it Solved if you haven't done that already!

All the best!