Assign the value to a temporary integer in your w/f. Why would month() etc would help you get the integer value of a date field? Cheers Ben
_____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jack Samson Sent: January 18, 2008 4:36 PM To: [email protected] Subject: Re: Date field Question ** 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. Play now! <http://club.live.com/star_shuffle.aspx?icid=starshuffle_wlmailtextlink_jan> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
