[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.....
- Subject: Re: Thanks for hints; more info.....
- From: Alex Perrin <APerrin@PULTE.COM>
- Date: Wed, 13 May 1998 16:57:24 -0400
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
>