Need formula for Lastweek, MTD and LastMonth

[system]

Hi Sujatha,

Please find this link…Hope u will get some idea

120×120 10.4 KB

Hi Experts, I am having some reports, In which I need to display Day, Week, Month, Week to Date, Month to Date, Year to Date. I am using BOXiR2, Oracle 9i as back end. I have searched entire forum, But I did not the proper solution to my requirement. Please let me know the logic. NOTE: I don’t have these columns in the DB, I need to create it in the Universe level. Table Name: CUSTOMER Coulumn Name: DATE Based on the user selection in the report level, I need to display the report in Cr…

Thanks,
Vasu

---

vasu237 (BOB member since 2007-02-19)