year to date

[system]

hi all,

i wanted to know thet how to apply year to date concept in efashion.

kindly help me on this .

Thanks

---

kumarsawan (BOB member since 2011-07-18)

[system]

Hi,

Check this out

DB-specific Relative Dates SQL Server, Oracle, Netezza, DB2

As per this topic on Oracle relative dates, here’s the same set of dates in SQL Server. Please note that some may not work on SQL Server 2000, but all definitely work in 2005/8. Yesterday cast(convert(char(10),dateadd(d,-1,getdate()),23) as datetime) Today cast(convert(char(10),getdate(),23) as datetime) The following also works for today: dateadd(dd, datediff(dd,0,getdate()), 0) Start of Current Month cast(convert(char(7),getdate(),23)+'-01' as datetime) End of Current Month dateadd(d,-1…

---

M H Mohammed (BOB member since 2010-06-16)

[system]

Hi Mohammed

I haven’t got the relevant answer that how to calculate the YTD at report level.

Kindly assist me .

Thanks

---

kumarsawan (BOB member since 2011-07-18)