473,320 Members | 1,909 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Querying with Dates

29
Hi all

I am trying to run a query, that brings me back all the jobs done in a month.. currntly the month in stored as 00-XXX-07. so its like 10-apr-07.
i am trying to run a query that will bring me all jobs from the month that the user specifies.
i have inputted this line, but it doesnt work.
Like "*" & [Please Enter A Month Type] & "*"

Because i am working with dates, are there any differences

Please Help
Apr 18 '07 #1
3 1222
Shokoth
29
i have actually solved the above, but i was wondering how u show just the current month in a query. I have tried to write date ().mm, and oders but they didnt work
is there a way just to place the currnt month on queries.
Apr 18 '07 #2
pks00
280 Expert 100+
i have actually solved the above, but i was wondering how u show just the current month in a query. I have tried to write date ().mm, and oders but they didnt work
is there a way just to place the currnt month on queries.
If its a date field, u could just use the format command

format(datefield,"mmm")
Apr 18 '07 #3
NeoPa
32,556 Expert Mod 16PB
(Literal DateTimes and Their Delimiters (#).) may help you to understand how to deal with Dates / Times in queries. Remember, a date is not the same as a string with date data stored in it.

BTW.
Please remember to provide a meaningful Title for any threads started (Please Use Appropriate Titles for New Threads!). This helps to ensure that other members, and also the general public, will have a better chance of finding answers to any similar questions.
I've changed this one but please remember in future.
Apr 20 '07 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

7
by: ndn_24_7 | last post by:
Hello all, I'm trying to run a query to make a report. My database is a incident reporting database. I'm tryng to make a monthy report for incidents. The field I need to query in the date field...
2
by: toedipper | last post by:
Hello, MYsql and PHP If I want to extract data with todays date then it's 'where blab blah = current_date()' For yesterday it's 'where blah blah = current_date()-1' But can anyone tell...
6
by: Greg | last post by:
I am working on a project that will have about 500,000 records in an XML document. This document will need to be queried with XPath, and records will need to be updated. I was thinking about...
4
by: Stewart Allen | last post by:
I'm trying to filter a table that has 2 date fields, the first date will always have a value but the second will only occasionally has a value. Each date field also has a corresponding text field...
0
by: roiavidan | last post by:
Hi, I'm having a bit of a problem with a small application I wrote in C#, which uses an Access database (mdb file) for storing financial data. After looking for a similiar topic and failing to...
4
by: dmeiser | last post by:
Hello all: I need to query a table for events that happen on third shift ( 11 PM to 7 AM ) in a date range. In the past, I've only needed to query for one night, but I now need to query for 14...
4
by: minapatel | last post by:
Probably a simple solution but can't find it myself can someone help????? I would like to extract data from a table where the dates are between two dates and then loop to select more data for...
33
Cintury
by: Cintury | last post by:
Ok the problem originally started with me wanting to compare the dates entered on one form with the dates entered on a different form's subform (I hope that wasn't too confusing). Thru numerous...
5
by: Dollarstar | last post by:
I'm not sure if I've disribed this right but this is what I need: I have two fields with dates in. I need some code that will look at the two dates and if the dates are more than four days...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.