I have one report which has two different date format for a single field
in some pages date format is dd/mm/yy and in some pages its dd-MMM-yy.
I configured report for dd/mm/yy. so for other format loading is failed.
Anyone has idea how can i store two different date format in one field.
(I know , we can store as String, But i want to store as date type)
Hello Kasim,
If you want to store in a single date field 2 different date format, you simply cannot. Per field is only 1 date format allowed.
BUT... by being a little creative :-D there is a way around it!!
At my knowledge, there are several methods:
1) You create a script to change the date in the document itself before loading it.
2) You write a user exit in arsload, in order to change "on-the-fly" the date format used in the document while doing the process to archive the document.
3) you use 2 applications, one for the format 1, and the second for the format 2.
Maybe others have some ideas... but these are the 3 that comes in my mind in 2 seconds !!
Sincerely yours,
Alessandro
Hi Alessandro
Thanks for reply
Customer is not allowing to change the data.
Creating two applications also is not practical in our scenario.
We decided to store date value as String.
Hi Kasim,
using an index exit you can normalise the date field.
But of course it's better to speak with the producer of the report to generate only one format.
regards
Egon
Kasim
if you store the date as a string, if you haven't you should also store the date you load the report as a date field to use as your segment date.