• Access 365 change Date Format of table contents

    Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » Access 365 change Date Format of table contents

    Author
    Topic
    #1773503

    I want our dates in mm/dd/yyyy format, ie 2 digits for month & day incl leading zero, & 4 year digits. I’ve changed the input mask from…
    99/99/0000
    to…
    00/00/0000
    …which should take care of this going forward.

    Is there an easy/auto way to change the existing table contents?
    The only issue is the leading zeros for mm & dd.

    PS fyi re Input Mask:
    “9” means user MAY enter a digit;
    “0” means user MUST enter a digit

    Lugh.
    ~
    Alienware Aurora R6; Win10 Home x64 1803; Office 365 x32
    i7-7700; GeForce GTX 1060; 16GB DDR4 2400; 1TB SSD, 256GB SSD, 4TB HD

    Reply To: Access 365 change Date Format of table contents

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: