Skip to Content
0
Apr 04, 2006 at 04:19 PM

Incorrect date format between provider and queries

22 Views

Hi BW experts!

I have a key figure (last date) defined as DATS and aggregation defined as MAX.

In my provider the data was storaged correct, as following above:

(dates in format dd.mm.yyyy)

. Customer 1, last date 21.03.2006;

. Customer 2, last date 10.03.2006;

. Customer 3, last date 26.01.2006.

But, in my queries (by EXCEL) these data are showed so:

1 | 21/03/2006

2 | 03/10/2006 (incorrect, correct is 10/03/2006)

3 | 26/01/2006

I checked my pc and SU01 configurations. In both of them there are date format dd/mm/yyyy.

Anybody can help me. please?

Thanks,

Silvio Messias