Firstdate of Previous Month

[system]

Hi,

The database I am using in IDT is Sybase and is all the want to achieve is that to retrieve the First date of Previous Month in IDT.

For Example: Current date = 5/11/2015

Expected Result for Firstdate of Previous Month : 1/10/2015.

Problems faced:

Functions like: Convert,cast, todate is not available in IDT for Sybase database by making use of Derived table.

---

amlenduk (BOB member since 2014-08-28)

[system]

[Moderator Note: Moved from CMC to Semantic Layer / Universe Designer]

---

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

[MarkP]

Have a look at Debbie’s post:

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…

[system]

Functions like: Convert,cast, todate is not available in IDT for Sybase database by making use of Derived table.

Please elaborate here, are you saying you can’t use Sybase functions, in a derived table, in the IDT?
I find that very hard to believe.

---

Mak 1 (BOB member since 2005-01-06)

[system]

Even though you can’t see functions in the functions list, you can still use them in IDT. You just type them in. Any valid SQL will work in IDT.

---

MichaelWelter (BOB member since 2002-08-08)