Dateserial - Microsoft Access Forum - Computer Learning Zone


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Dateserial

Leo Rivera

2 years ago

Hi you all, I did a table of task that require to performs during different months during the year. Then I did a query and filter the field where the months was assigned, but I have no result. If I enter Like "January" on the criteria I have good result but I want to create this criteria dynamic using the current month therefore I enter Like "Dateserial(Month(date())" but I have cero result. What can I do?

	Kevin Robertson @Reply 2 years ago
The syntax for DateSerial is wrong see this video: DateSerial Will need to see your query before I can offer more help.

Leo Rivera OP @Reply

2 years ago

The field contain the months where the task needs to be attend example: January, March, May. In the query criteria I want to filter all the task that contain January for example. I did the Like "January" and all good all the field that contain January appears. What I want to do is create a criteria that run automatically with the current month. I though this can be used Dateserial for this but when I enter Like "Dateserial(month(date())" I got cero result. What do you need to see additional to this?

	Leo Rivera OP @Reply 2 years ago
Never mind I figure it out. The field need to be in number and the criteria is Month(Now()). Appreciate it.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View