All,
ARS 6.3
SQL Server 2000
I am trying to obtain the numeric value for a date field (1191960) which is
really 1/1/1960. I have tried to use the MONTH(), DAY(), YEAR() functions in a
filter which work fine until I select a value before epoch time. The value I
get is 12311969. Is their another way to do this with a Date field. I know
this works fine with a Date/Time field..
Thanks,
Jackson
_________________________________________________________________
Climb to the top of the charts! Play the word scramble challenge with star
power.
http://club.live.com/star_shuffle.aspx?icid=starshuffle_wlmailtextlink_jan
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"