Currently Month and Next Month (1 Viewer)

DaRTHY · Apr 2, 2015

Hello guys,

I need to Criteria between currently Month and Next Month. (we are in April because of this im giving this example : 01.04.2015-31.05.2015)

I tried this code but its not working :

Dateadd("M") between DateAdd("M"+1)

if you have a solution please share to me

Ty.

pr2-eugin · Apr 2, 2015

How about,

Code:

BETWEEN [URL="http://www.techonthenet.com/access/functions/date/dateserial.php"]DateSerial[/URL]([URL="http://www.techonthenet.com/access/functions/date/year.php"]Year[/URL](Date()), [URL="http://www.techonthenet.com/access/functions/date/month.php"]Month[/URL](Date()), 1) AND DateSerial(Year(Date()), Month(Date()) + 2, 0)

? DateSerial(Year(Date()), Month(Date()), 1)
01/04/2015 
? DateSerial(Year(Date()), Month(Date()) + 2, 0)
31/05/2015

DaRTHY · Apr 2, 2015

I copied your first code "BETWEEN DateSerial(Year(Date()), Month(Date()), 1) AND DateSerial(Year(Date()), Month(Date()) + 2, 0)"

but its not working first error was Sytax and i used "" and now there is a new error :
Data type mismatch in criteria expression.

pr2-eugin · Apr 2, 2015

So my guess is the field you are trying to use the criteria is not Date type is it? It is of type Text?

If so, you understand why the error !

DaRTHY · Apr 2, 2015

Date Type is Date/Time
its correct.
a million dollars question : if date type is correct why do i get this error message

pr2-eugin · Apr 2, 2015

Could you please post the SQL?

DaRTHY · Apr 2, 2015

i did not write to sql code im using design view. Sql code seems so funny now

and i cant send them because its forbidden from company :S

namliam · Apr 2, 2015

you may need to replace the , by ; depending on your regional settings.

Brianwarnock · Apr 2, 2015

DaRTHY said:
I copied your first code "BETWEEN DateSerial(Year(Date()), Month(Date()), 1) AND DateSerial(Year(Date()), Month(Date()) + 2, 0)"

but its not working first error was Sytax and i used "" and now there is a new error :
Data type mismatch in criteria expression.

This post suggests to me that you put " around the statement , they are not needed.

Brian

DaRTHY · Apr 7, 2015

BETWEEN DateSerial(Year(Date()); Month(Date()); 1) AND DateSerial(Year(Date()); Month(Date()) + 2; 0)

Okey this time i wrote ; instead of , now i dont get any error. But it shows nothing...

shall i write this part too ??

? DateSerial(Year(Date()), Month(Date()), 1) 01/04/2015 ? DateSerial(Year(Date()), Month(Date()) + 2, 0) 31/05/2015

the problem is, i want to this function automatically update itself. For example next month i ll need this 1.5.2015 to 31.06.2015

pr2-eugin · Apr 7, 2015

Please post the Full SQL, with some sample data. If everything fails, please post a stripped DB.

How to Upload a Stripped DB.

To create a Sample DB (to be uploaded for other users to examine); please follow the steps..

1. Create a backup of the file, before you proceed..
2. Delete all Forms/Queries/Reports that are not in Question (except the ones that are inter-related)
3. Delete auxiliary tables (that are hanging loose with no relationships).
4. If your table has 100,000 records, delete 99,990 records.
5. Replace the sensitive information like Telephone numbers/email with simple UPDATE queries.
6. Perform a 'Compact & Repair' it would have brought the Size down to measly KBs..
7. (If your Post count is less than 10 ZIP the file and) Upload it..

Finally, please include instructions of which Form/Query/Code we need to look at. The preferred Access version would be A2003-A2007 (.mdb files)

DaRTHY · Apr 7, 2015

Its working. Ive been worked on DB and I found my fault. Sorry about that

Thank you so much

Problem Solved.

you can close the Thread

pr2-eugin · Apr 7, 2015

Glad that you have it sorted. Please refrain from Double Posting : http://stackoverflow.com/questions/29488275/access-criteria-currently-month-and-next-month

For more information on Why should you not post the same question in several Forums, read HERE.

namliam · Apr 9, 2015

DaRTHY said:
I found my fault.

And what was your fault? Just for anyone else that finds your thread and has a simular problem

DaRTHY · Apr 9, 2015

namliam said:
And what was your fault? Just for anyone else that finds your thread and has a simular problem

My fault was about Relationship

Currently Month and Next Month (1 Viewer)

DaRTHY

Registered User.

pr2-eugin

Super Moderator

DaRTHY

Registered User.

pr2-eugin

Super Moderator

DaRTHY

Registered User.

pr2-eugin

Super Moderator

DaRTHY

Registered User.

namliam

The Mailman - AWF VIP

Brianwarnock

Retired

DaRTHY

Registered User.

pr2-eugin

Super Moderator

DaRTHY

Registered User.

pr2-eugin

Super Moderator

namliam

The Mailman - AWF VIP

DaRTHY

Registered User.

Similar threads

Users who are viewing this thread