If it's a web only application, why not use JavaScript to display dates in the
correct format on the screen? We've been using this for quite a while now
without any problems:
- Store the date/time as you do normally in a date/time field, but add an extra
computed field for every date/time field in which you store the date/time as a
text value in a common format (ie yyyy/mm/dd hh:mm:ss, which sorts correctly
also).
- When displaying a date, use a JavaScript function to transform the text
date/time in the format you'd like.
This can easy be used everywhere you'd want to display the date.
Sounds easier to me than adding a wqo/ wqs agent everywhere.
If it's a web only application, why not use JavaScript to display dates in the correct format on the screen? We've been using this for quite a while now without any problems:
- Store the date/time as you do normally in a date/time field, but add an extra computed field for every date/time field in which you store the date/time as a text value in a common format (ie yyyy/mm/dd hh:mm:ss, which sorts correctly also). - When displaying a date, use a JavaScript function to transform the text date/time in the format you'd like.
This can easy be used everywhere you'd want to display the date.
Sounds easier to me than adding a wqo/ wqs agent everywhere.