Formatting submission date format

  • Profile Image
    canefe
    Asked on September 15, 2014 at 07:27 AM

    Hello,

     

    How can i get submission date like this format =2014-04-22 14:54:51

     

    Thanks,

  • Profile Image
    Ben
    Answered on September 15, 2014 at 10:00 AM

    Hi Canefe,

    Can you please tell me where you would like to format this date?

    The required parameters would be YYYY-MM-DD HH:MM:SS to display the date in the format you have shown above.

    If you are using spreadsheet, such as Libre Calc you can do that by following these steps:

    Select the date column

    Right click on the column header and select Format Cells...

    On this new window go a bit down to the field marked as: "Format Code" and past the formatting code from above: YYYY-MM-DD HH:MM:SS

    Now click OK and your fields should now be formatted correctly :)

     

    It is very similar in Google docs as well:

    Mark the column with the dates:

    Make sure that there is a space after day and you will need to click on those arrows on the right of the hour/minute/second to select if you want the 0 in front to be shown or not ie (2:2:13 or 02:02:13). If it does not allow you to click on it to add the text, just click where there is already some text and hit right or left arrow until you get to the point where you want to add any characters.

    I hope that this helps you, but do let us know if you have any questions or if this was not what you had in mind.

    Best Regards,
    Ben