Need help regarding SAP Business Object SQL Query Script

[Former Member]

Hi,

My requirement is...

I need to set my query to refresh automatically by the date offset filter.

If the current date (Today's Date) is between 4th to 30th/31st of the month then my offset will be "0" and if the current date (Today's Date) is between 1st to 3rd then offset will be "1".

Below is my current object SQL Script

   vedw.wo_header_drvd3_view.cal_offset  BETWEEN  0  AND  0

Please Help.

Thanks!

Moinuddin Shaikh

[Former Member · Accepted solution]

Hi,

I got the solution.

CASE

WHEN TO_NUMBER ( TO_CHAR (myTable.SomeDate, 'dd') ) < 4

   THEN 1

   ELSE 0

END

[Former Member]

Hi,

Can anyone please reply to my question????

___________________________________________________

If anyone unable to understand my question... can help me to convert the below mentioned formula into SAP BO SQL Script.

=IF(DAY(NOW())<4,1,0)

Thanks!

Moin