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"
