Date field with time is not getting displayed properly!

[#1]

Hi

In one of my pivot table. I have 2 date fields(without time) PLANSTART and PLANFINISH which I am converting it to date field(without time). When I displaying all these fields in the pivot table, fields without time are getting displayed as it is but fields with time are not getting displayed properly.

Can some one please help me out on this.

[nathanfurby · Accepted solution]

If you want to format the values in date format but keep the timestamp then use the following in load script:

TimeStamp(PLANFINISH) AS PLANFINISH

[#3]

Hi Nathan

Thanks for your help. That does the trick! 🙂