MaximS
06-07-2009, 02:13 AM
hi,
Can anyone advise me how to test if current day is Sunday?
If yes I'd like to show the data from last week otherwise data from current week.
So far my code looks like that
SELECT
MNM.DIM_DATE.T_DATE,
SUM(MNM.FACT_RCD.COUNT_UNITS)
FROM
MNM.DIM_DATE,
MNM.FACT_RCD
WHERE
( MNM.FACT_RCD.T_DATE=MNM.DIM_DATE.T_DATE )
AND
( MNM.DIM_DATE.CURRENT_WEEK='0' )
GROUP BY
MNM.DIM_DATE.T_DATE
And for current week I'm using:
( MNM.DIM_DATE.CURRENT_WEEK='C' )
Can anyone advise me how to test if current day is Sunday?
If yes I'd like to show the data from last week otherwise data from current week.
So far my code looks like that
SELECT
MNM.DIM_DATE.T_DATE,
SUM(MNM.FACT_RCD.COUNT_UNITS)
FROM
MNM.DIM_DATE,
MNM.FACT_RCD
WHERE
( MNM.FACT_RCD.T_DATE=MNM.DIM_DATE.T_DATE )
AND
( MNM.DIM_DATE.CURRENT_WEEK='0' )
GROUP BY
MNM.DIM_DATE.T_DATE
And for current week I'm using:
( MNM.DIM_DATE.CURRENT_WEEK='C' )