Can I get a help please on specifying the date format field in jasper ?

[mohammed.sardar]

I get the date format as '2-SEP-14' when I execute my funciton in Oracle. But when it returned to Jasper it automatically appends TIME STAMP to it.!  I try the below in Edie Expression fields but getting an error but not the report. 

 

How should I change the format in Jasper 4.0.2

 

 new SimpleDateFormat("DD/MMM/YY").format($F{RECEIPT_DATE})   - Is it right ?

 

Many thanks

Mohammed

 

 

 

[rajesh.sirsikar]

Hi,

Its pretty simple. Use the below expression

DATEFORMAT($F{ORDERDATE},"dd-MMM-yy") (Change teh date field to your field)

and see teh magic :-)

Regards

Rajesh Sirsikar

www.rajeshsirsika.com (for most of your jasper questions)

[rajesh.sirsikar]

Ill come up with a blog on this soon...:)

[mohammed.sardar]

Hi Rajesh,

 

Thanks very much for your reply. I used pattern property before getting your answer though it helps me too and others as I hope. Your website w3.rajeshsirsika.com does not seem to work for me. I'm interested to approach the site for some of my jasper doubts. Thanks

Mohammed

[rajesh.sirsikar]

Hi

there was a typo...it is www.rajeshsirsikar.com

 

[mohammed.sardar]

could you please let me know a best jasper e-book or book if you wish? Currently I'm referring Packtpub.iReport.3.7.Apr.2010. Ofcourse I will also refer the Net. As you have come across many jasper concepts I'm asking you. If you like pls suggest. Thanks