Date objects

[system]

How to create the

Current Month to End of Year

Current Week to End of Year

objects at designer level. The calender is normal calender which starts from jan and ends in Dec.

I am using oracle database. and i have daydate object at Universe.

---

krish007 (BOB member since 2006-10-06)

[system]

Hi,

This topic may get you started:

Oracle Relative Date Functions

Just thought I’d help people out by posting some as a quick reference Yesterday: trunc(sydate)-1 Today: trunc(sysdate) Start of Current Month: trunc(sysdate,'mm') End of Current Month: last_day(sysdate) Start of Previous Month: trunc((trunc(sysdate,'mm')-1),'mm') End of Previous Month: trunc(sysdate,'mm')-1 Start of Current Quarter: trunc(sysdate,'q') End of Current Quarter: add_months(trunc(sysdate,'q'),3)-1 Start of Previous Quarter: trunc(trunc(sysdate,'q')-1,'q') End of Previous Qu…

---

Marek Chladny (BOB member since 2003-11-27)

[system]

I’m not really sure what you’re asking for. do you need the nuber of days between the two dates, a list of dates between the two dates, something completely different…

---

pablolee (BOB member since 2008-07-29)

[system]

pablolee,

I have to create pre built conditions at universe for the below

Current Month to End of Year

Current Week to End of Year

From the current date to End of Year the client will retrive the data
(there will be planned data which will be available at client database)

---

krish007 (BOB member since 2006-10-06)

[MarkP]

Define an object “Start of Current Month”
Define an obejct “End of Current Year”

Create a pre-defined condition as

table.date_column between @Select(Start Of Current Month) and @Select(End of Current Year)

Obviously you’ll need to apply the correct syntax to the above but that’s the basic principle.

[system]

Thanks Mark p
I have created the objects and they are parsing.

---

krish007 (BOB member since 2006-10-06)