RE: [MS_AccessPros] RE: Date field

Bill,Search Help on "Date Functions" and you should discover how to convert a date value to a month or year or day or quarter or whatever. Dates are basically a numeric value storing the number of days since 12/30/1899. If you open the debug window (press Ctrl+G) and enter: ? clng(Date()) You will find that today is 40905. The Time is also stored in the number but is the decimal portion ? cdbl(now()) 40905.4468055556 At exactly noon today, it will be 40905.5 ( .5 is one half of a day) Duane HookomMS Access MVP
To: MS_Access_Professionals@yahoogroups.com
From: Bill.Singer@at-group.net
Date: Wed, 28 Dec 2011 10:07:11 -0600
Subject: RE: [MS_AccessPros] RE: Date field

Duane,

I believe I was watching a video on normalization, though I cannot find the

link now. I will use the standard date formatted field for not and see how

it goes. I will then have to figure out how to pull all the information

that relates to a specific month and year. I am not quite sure how to do

that yet but I will be sure to let you know if I get stuck.

Thanks,

Bill

-----Original Message-----

From: MS_Access_Professionals@yahoogroups.com

[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Duane Hookom

Sent: Wednesday, December 28, 2011 9:42 AM

To: Access Professionals Yahoo Group

Subject: RE: [MS_AccessPros] RE: Date field

Bill,Not sure of the context of Crystal's "own date field" but a date is a

date is a date. I would not consider changing a date field to anything else.

I might apply different formats or extract parts of the date with the large

number of date related functions. If I was tracking birthdays and had only

the day and month (no year), I might consider using fields for day and month

since a date field stores the year. Duane HookomMS Access MVP

To: MS_Access_Professionals@yahoogroups.com

From: Bill.Singer@at-group.net

Date: Wed, 28 Dec 2011 09:19:03 -0600

Subject: [MS_AccessPros] RE: Date field

I watched one of Crystal's videos and she created her own date field

rather

than use the date formatted field that access has. She created 3 separate

fields for month, day and year. I am going to be pulling some data out of a

database by month and I am wondering if creating my own date fields is going

to make this easier. I am thinking it will be easier to pull data for

February if I just run a query for all data where the month equals "2" and

the year equals "2012".

Any thoughts?

Bill

Minnesota

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links

-----

No virus found in this message.

Checked by AVG - www.avg.com

Version: 2012.0.1901 / Virus Database: 2109/4708 - Release Date: 12/28/11

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/