Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
Hi Nathan
Thanks for your help. That does the trick! 🙂