Getting day in the Date in TextField

[mikij]

 Hi,

 

I have simple Date field in my database and it is returned in iReport query. But now I want to know which day is in that Date (e.g., 21/4/2008, is 21). I cannot do it with Calendar.getInstance()... because iReport doesn't allow two lines, and I cannot put this expression in just one line. How can I do this ?

 

--

Thank you in advance, Miki

[kchaudhry]

You can do this in your query. The following syntax will work with SQL Server and return the day.

 

 

Code:

select datepart(dd,yourdatefield)