[access] display month of a date
rodrigue62
Posted messages
201
Status
Member
-
Jean_Jacques Posted messages 1045 Registration date Status Member Last intervention -
Jean_Jacques Posted messages 1045 Registration date Status Member Last intervention -
Hello,
maybe the solution to my problem has already been given, but since I haven't been able to access the forum's search engine for two days, I couldn't find it, so if that's the case, thank you for providing me with the link to the solution.
Actually, I have a report that involves a cross-tab query, and the dates involved all pertain to a specific month since it’s a dialog box that asks me to select the month before running the report. However, I would like to display this month as a title at the top, so I opened a field in which I entered: "=month([DATE])" but the result returned is in numbers (e.g., 1 for January) whereas I want the full name of the month to be displayed, so it shows January and not 1. Is this possible?
I hope I have been clear enough; if not, please feel free to ask for more details, and thank you for your help.
maybe the solution to my problem has already been given, but since I haven't been able to access the forum's search engine for two days, I couldn't find it, so if that's the case, thank you for providing me with the link to the solution.
Actually, I have a report that involves a cross-tab query, and the dates involved all pertain to a specific month since it’s a dialog box that asks me to select the month before running the report. However, I would like to display this month as a title at the top, so I opened a field in which I entered: "=month([DATE])" but the result returned is in numbers (e.g., 1 for January) whereas I want the full name of the month to be displayed, so it shows January and not 1. Is this possible?
I hope I have been clear enough; if not, please feel free to ask for more details, and thank you for your help.
8 answers
Good evening,
Here is the great secret to obtaining the date in plain text:
=Format(Date();"Date, complete")
Sincerely
Science only finds what has existed since forever.
Hubert REEVES
Here is the great secret to obtaining the date in plain text:
=Format(Date();"Date, complete")
Sincerely
Science only finds what has existed since forever.
Hubert REEVES
Re-good evening,
Upon re-reading, I believe that:
="Month processed: " & Format([DateField];"\ mmmm"" ""yyyy")
is appropriate for your needs...
mmmm -> month in its literal form
yyyy -> year in 4 digits
That is: May 2006 (for example)
Best regards
Science only finds what has always existed.
Hubert REEVES.
Upon re-reading, I believe that:
="Month processed: " & Format([DateField];"\ mmmm"" ""yyyy")
is appropriate for your needs...
mmmm -> month in its literal form
yyyy -> year in 4 digits
That is: May 2006 (for example)
Best regards
Science only finds what has always existed.
Hubert REEVES.
Hello
I have an Access query with a date field in the format 11/03/2008
but I only want to have the month in this field
thank you for the help
I have an Access query with a date field in the format 11/03/2008
but I only want to have the month in this field
thank you for the help
Hello,
To display the month, the syntax to use is as follows:
In SQL:
SELECT Month([<Field_Name_Date>]) AS Month, [<table_name>].[<Field_Name_Date>]) FROM [<table_name>];
Or (in design mode) on the 'Field' line
No: Month([<Date_Field>])
Best regards
Science only discovers what has existed forever.
REEVES Hubert.
To display the month, the syntax to use is as follows:
In SQL:
SELECT Month([<Field_Name_Date>]) AS Month, [<table_name>].[<Field_Name_Date>]) FROM [<table_name>];
Or (in design mode) on the 'Field' line
No: Month([<Date_Field>])
Best regards
Science only discovers what has existed forever.
REEVES Hubert.
When I set the value in creation mode on the field, it asks me to enter a parameter value
<champ_date>
<champ_date>
Hello
I have a report in Access and I would like to have a barcode in the report.
I want to create a receipt with a barcode based on a report.
Thank you for giving me a hand.
I have a report in Access and I would like to have a barcode in the report.
I want to create a receipt with a barcode based on a report.
Thank you for giving me a hand.
Hello,
I would like to group data by month in Access 2007. Can you please help me?
Thank you in advance.
I would like to group data by month in Access 2007. Can you please help me?
Thank you in advance.
