Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Date format issues with SQL Server as database
Migrateduser
<p>Hi All, I've developed reports with dates as parameters and for formatting I'm using MXReportSqlFormat functions.</p><p> </p><p>While selecting from datelookup I give as 2013-09-19, But internally it passes year as 0013.</p><p> </p><p>Could you please shed some light, how to use the dates and formats ? I've tried all the options I know, is there anyway I can replace that 2 zeroes with 20, using replace function ?</p><p> </p><p>Thanks,</p><p>Suresh.</p>
Find more posts tagged with
Comments
There are no comments yet