Auto populate date field

关注

Edit Toth

• 2018年03月15日 16:56

I am trying to auto-populate date field from SharePoint to AgilePoint form. The date control doesn`t work currently so I am would like to populate a text control. The date format comes back in US format.

Anyone has any suggestion how to change it to UK format?

0

• 

  Lucas Drege

  • 2018年03月16日 22:13

  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?

  0

  评论操作 固定链接
• 

  Edit Toth

  • 2018年03月19日 09:35

  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

  

   

  0

  评论操作 固定链接
• 

  Lucas Drege

  • 2018年03月20日 20:58

  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
  
   

   

  1

  评论操作 固定链接
• 

  Edit Toth

  • 2018年03月21日 12:13

  Great idea, it looks fine now. Thank you!

  0

  评论操作 固定链接

请先登录再写评论。