Date Display

[e_c]

Hi Experts,

When i execute the query in the analyzer, the date is field is not getting displayed in the report, Instead of date it is displaying as #.

Any suggestions, appreciated in advance.

[former_member222556 · Accepted solution]

Hi,

1. means Date is not in Target corresponding to the given records

-->check which date is this..

-->check the data in target (Cube/ DSO) for those record .

-->check query as well, whether any kind of restriction is there on date.....

best regards

Obaid

[Former Member]

hi,

Check in the infoprovider any # values is coming in that date field if it is there the np.if it is in info provider then also u want to restrict mens u can exclude that value in query level.check the data is loading from flatfile.

Thanks,

Sai.

[Former Member]

Hi Eswar

The # value could be due to the record being blank in the underlying infoprovider. Please check the data records in the underlying infoproviders.

If not, then check in analyzer it could be an issue with the excel formatting of the column as well due to which valid date is coming as #.

Hope this helps.

Regards,

Ninad