How to isolate the day-value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

query on date 1
Query Based on Weekdays vs Weekend 4
Calculate buisness days rather than calendar days 2
Excel Dragging countif formula with changing criteria 3
How do I get Min and Max to work with international date format? 4
Date Format in a Query 5
Cross tab query solution 4
Sorted and Unique Date Period 2

Back
Top