Tag Quey (InSQL Connector) in History Mode Start Date End Date Issue

[Former Member]

Hi All,

We are working on SAP MII 12.1.5 build 83 and facing problem with tag query in history mode following are details.

Data Server configured successfully connector is InSQL connection type is TAG with date format (MM-dd-yyyy HH:mm:ss).

In Tag Query (History Mode) we are passing Start Date and End Date in above mentioned date format (MM-dd-yyyy HH:mm:ss).

But we are not getting right data for given date range.

Suppose we pass 06-04-2010T00:00:00 as Start Date and 06-11-2010T00:00:00 as End Date to tag query it will return tags from 04-06-2010T00:00:00 to 11-06-2010T00:00:00.

For MII Simulator connector it is working fine.

Please provide some help for issue.

Regards,

Manoj Bilthare

[agentry_src · Accepted solution]

Hi Manoj,

What are the date formats for the MII server and historian you are using.

It looks like it is returning the right date range, but the format of the dates is changed.

Regards,

Mike

[Former Member · Accepted solution]

Hi Michael,

Thanks for your responce.

I have checked in database the date format is dd/MM/yyyy HH:mm:ss so i have replaced above format by this one it works.

Thanks

Manoj Bilthare