Post
Ask Question
Ramco Ramco

Ramco Ramco

  • 424
  • 3.5k
  • 576k

How the below code works

Feb 10 2025 3:08 PM

Hi

  How the below code works . It is used in Sap b1

SELECT 'True' FROM DUMMY WHERE

Add_days(Last_day(Add_days(Last_day(ADD_months(cURRENT_DATE,-2)),1) ),5) < cURRENT_DATE

AND TO_DATE('Total Selected Terms:','DD-MM-YYYY')  > Last_day(Add_days(Last_day(ADD_months(cURRENT_DATE,-3)),1))

and Monthname(TO_DATE('Total Selected Terms:','DD-MM-YYYY')) <> Monthname(cURRENT_DATE)

Thanks


Answers (1)