Date:         Mon, 3 Jun 2002 11:15:20 -0400
Reply-To:     "Dorfman, Paul" <Paul.Dorfman@BCBSFL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Dorfman, Paul" <Paul.Dorfman@BCBSFL.COM>
Subject:      Re: Dynamically assigning values to columns
Comments: To: Deepak Ramanathan <deepakramanathan@YAHOO.COM>
Content-Type: text/plain; charset=iso-8859-1

Deepak,

Before any suggestions, would you care to explain for us what the "one off
thingy" could mean? Just surmising, if you get one day less than expected,
it is easily fixed by insertin +1 in the right side of the formula...

Kind regards,
====================
Paul M. Dorfman
Jacksonville, FL
====================

> -----Original Message-----
> From: Deepak Ramanathan [mailto:deepakramanathan@YAHOO.COM]
> Hi all,
> I have a column which displays the date a particular event will occur.
> I need to create a column that will display the number of days left
> for that event but I need this to be dynamically changed based on the
> current date..
> i.e.
> today(03/06/02) the table will look like
> event_date         days left
> 10/06/02              7
>
> tommorow(04/06/02) the same table will look like
> event_date         days left
> 10/06/02              6
>
> I tried assigning the column a value of
> days_left = event_date - today()
>
> but that stores it in the table as a one off thingy...
>
> Any suggestions?
>
> Deepak
>


Blue Cross Blue Shield of Florida, Inc., and its subsidiary and
affiliate companies are not responsible for errors or omissions in this e-mail message. Any personal comments made in this e-mail do not reflect the views of Blue Cross Blue Shield of Florida, Inc.