Hello,

I am trying to get date inputs going to the data source into ISO 8601:2000 date-time from IA. Inspired by
Extensions to Date-Time Formats , I have added to my site profile

SET DTSTANDARD = STANDARD

, but using SQL Profiler, I still haven't seen dynamic Prompts in IA going back the DB Server in the required format.

(I need this format as I am going through a customized ODBC connection and this format triggers custom date handling I need.)

Any help in getting me toward a process I can train my IA users to do date filtering in the required format would be much appreciated.

Thanks

This message has been edited. Last edited by: TOM SCHULTE,

It looks like WF insists on converting the format, and maybe this is just unavoidable and even for the best.

Talking to an ODBC adapter, I get:

2010-08-17T09:43:42
converts to -->
{ts '2010-08-17 09:43:42'}

Talking to a SQL adapter, I get:

2010-08-17T09:43:42
converts to -->
'20100817 09:43:42'

In each case, I really wanted 2010-08-17T09:43:42 sent unchanged to the backend data source.

Perhaps someone just knows more about the rules of handling ISO 8601 dates and could explain it to me?

Thanks

Hi Tom,

If you have not done so, you may want to open a case with Customer Support Services for assistance, as this issue seems to be involved and very specific to your needs. The phone number is 1-800-736-6130, or access online at InfoResponse.

Cheers,

Kerry

I am marking this [CLOSED], then.

We are working with the current behavior and if we have questions beyond that, we'll open a case.

Don't know if this will help you, but there is a WebFOCUS date-time output format that will display the date-time with the T (and Z if desired). HYYMDU will display the T, while HYYMDUSZ will display both T and Z.

SET DTSTANDARD = STANDARD
-*
DEFINE FILE CAR
 XDATE/HYYMDUS WITH COUNTRY = DT(20100817 09:43:42);
END
-*
TABLE FILE CAR
 PRINT XDATE
 WHERE RECORDLIMIT EQ 1 ;
END

Thank you much, Dan. I am not after display format so much as the format of the date going back to the RDBMS. I thought they would be in the same format, but they are not. The format to the RDBMS is adapter-specific and not so much based on the display format.

quote:

...format that will display the date-time with the T (and Z if desired)...

Thank you Dan.

Reporting in ISO8601 format is exactly what I needed to do, and am glad to have found your post.