Ach so! I was led astray by the "numeric" and didn't see the coincidences between the date and integer (being too used to seeing the actual integers perhaps).
Sure, what you say sounds good. Is 1111960 January 11th or November 1st? Highly recommend your version with the lpad() My oops :) Cheers Ben -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Thomas Bean Sent: January 18, 2008 6:07 PM To: [email protected] Subject: Re: Date field Question If I understand correctly, Jack isn't looking for the integer value for the date field that is stored in the database -- he is looking to convert the date into a numeric string in a character field, in MMDDYYYY format. This can be accomplished by using the DATENUM function. For example: fields: myDate (date field), myDateChar (character field) Set field: myDateChar Set field value: (DATENUM( "mm",$myDate$) + DATENUM( "dd",$myDate$)) + DATENUM( "yyyy",$myDate$) A date value of 1/1/1960 will appear as "111960" in the character field. If you wish to left pad the month and day values with zeros, use the following set fields value: (LPAD(DATENUM( "mm",$myDate$),2, "0") + LPAD(DATENUM( "dd",$myDate$),2, "0")) + DATENUM( "yyyy",$myDate$) HTH, Thomas ----- Original Message ----- From: "Ben Chernys" <[EMAIL PROTECTED]> Newsgroups: gmane.comp.crm.arsystem.general To: <[email protected]> Sent: Friday, January 18, 2008 10:09 AM Subject: Re: Date field Question > 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" > ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
