date format help

[Former Member]

Hi All,

I am using backend as mysql.

my where condition is like this.

WHERE  date=STR_TO_DATE(DATE_FORMAT({?DATE}, '%Y-%m-%d %H:%i'), '%Y-%m-%d %H:%i')

datetime format in mysql is like this 2014-06-18 11:58:05

I am getting data in designer.But not getting data in crviewer in my application.

Please help

[former_member183750]

Is the .NET app an app you created, or is it a 3rd party app?

- Ludek

Senior Support Engineer AGS Product Support, Global Support Center Canada

  Follow us on Twitter

[Former Member]

Hi Ludhek,

Its a custom java application

[former_member183750]

OK. I moved your post to the SAP Crystal Reports, version for Eclipse SCN Space.

Assuming you are using CR for Eclipse(?) as you could also be using the BI Platform Java SDK...

By "custom java application", do you mean one written by you, or one written by some 3rd party?

- Ludek

[former_member205840]

Hi Divya,

Try to convert the date in designer to text like below and check

ToText({?DATE),"yyyy-MM-dd HH:mm:ss")

Sastry

[Former Member]

Hi Sastry and Abhilash,

This is my command objects where condition .I need to convert in query level

Also I did like this without converting but working fine in mysql and also in designer.

WHERE  date={?DATE}

Here parameter is dattime as above

Will this be work in application.

Please suggest

[abhilash_kumar]

If it works in the designer, ideally it should also work in the application.

If it doesn't, then someone who knows the application needs to look at what's causing the issue.

-Abhilash

[former_member205840]

Hi Divya,

Normally, as Abhilash said, if it is working with designer then it should work with any other application.

I am suspecting, it could be a viewer problem or may be the driver / code which you are using is unable to translate this.

-Sastry

[abhilash_kumar]

Hi Divya,

This looks like an issue specific to the application/cr viewer you're using.

Without knowing how this has been designed it would be difficult to troubleshoot why it doesn't fetch data. You should get in touch with the maintainer of the application to resolve this issue.

-Abhilash