Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Get 1st day of month

Posted on 2013-12-02
3
Medium Priority
?
499 Views
Last Modified: 2013-12-02
Dear Experts

In an Access Query I need to be able to return the 1st day of the month from a field

the field is [Invoice Date]

so if [Invoice Date] = 15/10/2013 then the result should come out as 01/10/2013 etc.  This needs to come out as a date rather than a formatted text field

Can anybody help?

Many thanks
0
Comment
Question by:correlate
3 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 2000 total points
ID: 39689970
this will give you the first date of the current month or any given date

dateserial(year(Date()),Month(Date()),1)

use like this
dateserial(year([Invoice Date]),Month([Invoice Date]),1)
0
 
LVL 61

Expert Comment

by:mbizup
ID: 39689974
Try this:

FirstDay: DateSerial(Year([Invoice Date]), Month([Invoice Date]), 1)


EDIT:

Too slow.
0
 

Author Closing Comment

by:correlate
ID: 39689979
Perfect - thank you very much
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

783 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question