Auto populate date field

Comments

4 comments

  • Avatar
    Lucas Drege

    Hi Edit,

    What is the location for the SharePoint site? Is it in the US or UK?  Is the date field populating the text control like you see it in SharePoint, or is it another format?

  • Avatar
    Edit Toth

    It is SharePoint Online so I guess US.

    On SharePoint the date fields is DD/MM/YYYY, the autopopulate shows as below then on the text control it displays in MM/DD/YYYY format

     

  • Avatar
    Lucas Drege

    Hi Edit,

    Please see the below steps,

     

    We need to change the regional settings to achieve a date format of MM/DD/YY. 

    Please navigate to Settings - Site Settings - Regional Settings and configure the location.

    After changing the regional settings,, the format will be MM/DD/YYYY, we will convert this using a calculated column.

     

    Create a column using the calculated type, and use the below format you'd like to display at runtime:

    Syntax: =TEXT(Date1, “DD/MM/YYYY”)


    SharePoint List Configuration Window:

    Configure form control, where to auto-populate:

    Which gives a runtime value of:

    Lucas

     

     

  • Avatar
    Edit Toth

    Great idea, it looks fine now. Thank you!

Please sign in to leave a comment.