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

<*> 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/