RE: How to isolate the day-value

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

The Day function will do this
Day(YourDate) will give you 14
There is also Month & Year functions which will give you the month & year
from a date value.

"Petterq" wrote:

> In a program I am writing I need to isolate the day value from a date. I have
> a date on the format dd.mm.yyyy, and need a formula in a query that returns
> only the dd value as a number. I.e. from the date 14.05.2005 i need the
> result 14. Do anyone have a formula that handles this?
.

Relevant Pages

  • Report recordset
    ... I tried both Format and print properties and finally fixed it with an update ... query. ... Prev by Date: ...
    (microsoft.public.access.reports)
  • RE: filtering a result
    ... It may need the date entered in US format. ... "Bakr Z via AccessMonster.com" wrote: ... I want to add another query to filter the ... Prev by Date: ...
    (microsoft.public.access.queries)
  • text to dates?
    ... I have a problem with this following query: ... I have a list of cells in the text format: ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • How do I split a cell in access query
    ... I have names in a table in the format Last, ... this column in a query to creat two columns for last and first. ... Prev by Date: ...
    (microsoft.public.access.queries)
  • How to isolate the day-value
    ... In a program I am writing I need to isolate the day value from a date. ... a date on the format dd.mm.yyyy, and need a formula in a query that returns ... Prev by Date: ...
    (microsoft.public.access.queries)