none
Date column

    Question

  • Hi friends,

      I'm having a date column in the powerpivot and the data type of the column is also date only but even then when I export the data to the power pivot it is still showing as datetime. Wondering how to set it up as date.?

    Thanks.

    Tuesday, February 18, 2014 8:06 PM

Answers

  • Hi Murali,

    Both DATE and DATETIME will be given the 'Date' data type in Power Pivot which by default is represented in the format 'dd/MM/yyyy : HH:mm:ss'. You can change how the date is displayed/formatted by using the 'Format' property found in the 'Home' tab of the Power Pivot window e.g. in your case there is no time part so you might want to chose the 'dd/MM/yyyy' formatting.

    You can read more about data types in Power Pivot here: http://technet.microsoft.com/en-us/library/gg413463.aspx

    Is there a particular reason this behaviour is bothering you?


    Regards,

    Michael

    Please remember to mark a post that answers your question as an answer...If a post doesn't answer your question but you've found it helpful, please remember to vote it as helpful :)


    Wednesday, February 19, 2014 6:48 AM
    Answerer

All replies

  • Hi

    use convert function to get oly date with

    exact format.  http://www.w3schools.com/sql/func_convert.asprefer this

    hi

    rhi

    Tuesday, February 18, 2014 8:18 PM
  • Hi Murali,

    Both DATE and DATETIME will be given the 'Date' data type in Power Pivot which by default is represented in the format 'dd/MM/yyyy : HH:mm:ss'. You can change how the date is displayed/formatted by using the 'Format' property found in the 'Home' tab of the Power Pivot window e.g. in your case there is no time part so you might want to chose the 'dd/MM/yyyy' formatting.

    You can read more about data types in Power Pivot here: http://technet.microsoft.com/en-us/library/gg413463.aspx

    Is there a particular reason this behaviour is bothering you?


    Regards,

    Michael

    Please remember to mark a post that answers your question as an answer...If a post doesn't answer your question but you've found it helpful, please remember to vote it as helpful :)


    Wednesday, February 19, 2014 6:48 AM
    Answerer
  • Hi

    use convert function to get oly date with

    exact format.  http://www.w3schools.com/sql/func_convert.asprefer this

    hi

    rhi

    Please read question, I'm not asking in sql server , it is in powerpivot..

    Thanks.

    Wednesday, February 19, 2014 4:57 PM
  • Hi Murali,

    Both DATE and DATETIME will be given the 'Date' data type in Power Pivot which by default is represented in the format 'dd/MM/yyyy : HH:mm:ss'. You can change how the date is displayed/formatted by using the 'Format' property found in the 'Home' tab of the Power Pivot window e.g. in your case there is no time part so you might want to chose the 'dd/MM/yyyy' formatting.

    You can read more about data types in Power Pivot here: http://technet.microsoft.com/en-us/library/gg413463.aspx

    Is there a particular reason this behaviour is bothering you?


    Regards,

    Michael

    Please remember to mark a post that answers your question as an answer...If a post doesn't answer your question but you've found it helpful, please remember to vote it as helpful :)


    Thanks Michael for the information.

    Yes it is bothering me cause I'm doing some analytics based on date and due to time it showing different results. 


    Wednesday, February 19, 2014 4:58 PM
  • Hi Murali,

    If you're able to provide some details about how the time is causing some undesired results in your analysis, we may be able to assist you further...


    Regards,

    Michael

    Please remember to mark a post that answers your question as an answer...If a post doesn't answer your question but you've found it helpful, please remember to vote it as helpful :)

    Wednesday, February 19, 2014 5:34 PM
    Answerer
  • Hi Murali,

    If you're able to provide some details about how the time is causing some undesired results in your analysis, we may be able to assist you further...


    Regards,

    Michael

    Please remember to mark a post that answers your question as an answer...If a post doesn't answer your question but you've found it helpful, please remember to vote it as helpful :)

    Hi Michael,

    As part of report, I need to show only date not datetime and that is my primary reason asking for this.

    Thanks.

    Wednesday, February 19, 2014 5:57 PM
  • Oh, ok. Thought there was a further issue :)

    Regards,

    Michael

    Please remember to mark a post that answers your question as an answer...If a post doesn't answer your question but you've found it helpful, please remember to vote it as helpful :)

    Wednesday, February 19, 2014 6:43 PM
    Answerer