1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

MS Access query - Get date format in query result

Discussion in 'The Lounge' started by ThrottleWorks, Dec 5, 2017.

  1. ThrottleWorks

    ThrottleWorks Excel Ninja

    Messages:
    1,761
    Hi,

    I am writing below mentioned query to get date for pending items.
    The results are correct. However, visually I can see date in number format.
    How do I mention in my query to show results in date format.

    Can anyone please help me in this.

    Code (vb):

    SELECT POC, [project name] as Project, [project status] as Status, [Planned End Date] as My_Date from my_database where [project status] ='PPP' order by POC
  2. Chihiro

    Chihiro Excel Ninja

    Messages:
    3,919
    Try something like...
    Code (vb):
    SELECT
        [POC],
        [project name] as Project,
        [project status] as Status,
        FORMAT([Planned End Date], "Short Date") as My_Date
    FROM
        my_database
    WHERE
        [project status] ='PPP' order by POC;
    ThrottleWorks likes this.
  3. shrivallabha

    shrivallabha Excel Ninja

    Messages:
    1,787
    Sorry for digressing from the topic!

    @Hui @r1c1
    I am thinking that for such questions we should have a section named "Other Office Applications" as once in a while users will come up with such queries regarding MS-Word or MS-Access and they may get good answers.

    Obviously, from solution viewpoint it really doesn't matter where a question is being posted.
    ThrottleWorks likes this.
  4. ThrottleWorks

    ThrottleWorks Excel Ninja

    Messages:
    1,761
    Hi @Chihiro sir. Thanks for the help. It is working great.
    By the way it seems Access wants to keep user busy with use of ' and " symbols.

    Have a nice day ahead. :)

Share This Page