[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: Thanks for hints; more info.....



  There is always the old standby of subtracting a day from the first of
the following month:

To get the last day of February, 1998:
  let $startdate = strtodate('03011998','MMDDYYYY')
  let $lastday = dateadd($startdate, 'day', -1)


> ----------
> From:         Sethurethenam
> Rajaram[SMTP:sethurethenam_rajaram@SMB.COM]
> Reply To:     SQR-USERS@USA.NET
> Sent:         Wednesday, May 13, 1998 5:16 PM
> To:   Multiple recipients of list SQR-USERS
> Subject:      Thanks for hints; more info.....
>
> Thanks for all the quick replies... guess what I didn't tell you,
> based on the
> replies I got, is this:
>
> this is not a PS implementation
> the database is db2 on a mainframe
>
> anymore ideas are welcomed. ;-)
>
> clark
>