Re: SQR Datediff?

["Thangavel Ravivarma (IT Dept. Langley)" <thangavel_ravivarma@OWFG.COM>]

        Try like this:

        LET #dif = DATEDIFF(STRTODATE($asoftoday), STRTODATE($effdt), 'DAY')

        -Thangavel



> -----Original Message-----
> From: Sam Spritzer [SMTP:SSpritzer@GW.CTG.COM]
> Sent: 1999/08/24 2:29 PM
> To:   Multiple recipients of list SQR-USERS
> Subject:      Re: SQR Datediff?
>
> I have noticed a lot of posting with reference to the various systems that
> have their own date arithmetic routines.
>
> I think it is important to keep in mind that SQR is not platform
> dependent.  Therefore, if you use its datediff function, you shouldn't
> have to worry about how PeopleSoft et al performs similar functions.
>
> SQRly yours,
> Sam
>
> <<< Nina Chou <nchou@BOOKCRAFTERS.COM>  8/24  5:04p >>>
> The following codes is what I extract from PeopleSoft AR32001.SQR.  Looks
> like
> the datediff are for SYBASEand MICROSOFT only.  There is a DAYS function
> for
> DB2.  For Oracle, you can just subtract the date variables.
> --------------------------------------------------------------------------
> -------------------------------------------------------
> #ifdef SYBASE
>  DATEDIFF(DAY, PS_STMT_ITEM1_TMP.DUE_DT, PS_STMT_ITEM1_TMP.ST_DT),
> #else
>  #ifdef MICROSOFT
>   DATEDIFF(DAY, PS_STMT_ITEM1_TMP.DUE_DT, PS_STMT_ITEM1_TMP.ST_DT),
>  #else
>   #ifdef DB2ALL
>    DAYS(PS_STMT_ITEM1_TMP.ST_DT) - DAYS(PS_STMT_ITEM1_TMP.DUE_DT),
>   #else
>    PS_STMT_ITEM1_TMP.ST_DT - PS_STMT_ITEM1_TMP.DUE_DT,
>   #endif
>  #end-if
> #end-if
>
>
>
>
>
> Sam Spritzer <SSpritzer@GW.CTG.COM> on 08/24/99 04:06:05 PM
>
> Please respond to SQR-USERS@list.iex.net
>
> To:   Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
> cc:    (bcc: Nina Chou/BookCrafters)
> Subject:  Re: SQR Datediff?
>
>
>
>
> I m tossing this in the wind but what version of SQR are you on?  Datediff
> is
> new for ver. 4.
> Sam
>
> <<< "Buchanan, Timothy" <buchanan@BIPERF.COM>  8/24  3:36p >>>
> Anyone get datediff function to work in SQR in an Oracle environment? I am
> trying to find the difference in days between 2 dates using the following
> code in a SQL statement:
>
>         LET #dif = DATEDIFF($asoftoday, $effdt, 'DAY')
>
> I get the error: Function or operator 'datediff' requires date argument.
>
> Using debug, I can see that $asoftoday and $effdt are equal to the
> following:
>
> ASOFTODAY = 24-AUG-1999
> EFFDATE = 01-JUL-1998
>
> Hmm..sure look like dates to me. I even tried to use STRTODATE on each
> variable, but it still gives me the same error. Any help?? Thanks.
>
> Timm