Current Date

[MarkP]

@tom2210

Hi,

I am trying to create Current date object in designer(E Fashion Universe) for practice on BO.i do not have any database install on my system.it is giving me date() function to use it but i don’t know how to use it.Plz help

If you don’t have a database installed, you won’t know the syntax.

Designer needs a connection to validate objects against.

I’d recommend getting SQL Express installed - http://www.microsoft.com/express/Database/

Relative dates are discussed in this topic:

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…