https://www.infopathdev.com:443/forums/50.aspx enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/116518.aspxMon, 19 Jun 2017 14:51:49 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:116518Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/116518.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=50&PostID=116518I may not be understanding. Is this a SharePoint List form? When you say "list view" do you mean the default view of the list in SharePoint? If so, I'd just add another column, default it to the value of the selected date / time, and format it to show only the date value. Modify the default view to show those columns (formatted as date display) instead of the columns the user fills out in the form (formatted as date / time).https://www.infopathdev.com:443/forums/thread/116517.aspxMon, 19 Jun 2017 14:08:27 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:116517cingram70https://www.infopathdev.com:443/forums/thread/116517.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=50&PostID=116517thanks for the reply - my assumption is that a workflow is required since the fields will not be populated until the form is opened and the dates are selected by the user. I've not had much luck populating additional fields within the same form in the time between it is opened and submitted, but if that's possible I would be happy to give it a shot.https://www.infopathdev.com:443/forums/thread/116498.aspxThu, 15 Jun 2017 22:49:37 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:116498Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/116498.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=50&PostID=116498I'm struggling a bit to understand what you are asking... Do you need to use a workflow for this, or will just a calculated column work? That is - is this new field also in the same library as the promoted data?https://www.infopathdev.com:443/forums/thread/116496.aspxThu, 15 Jun 2017 18:52:24 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:116496cingram70https://www.infopathdev.com:443/forums/thread/116496.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=50&PostID=116496I've got a SP list with a standard "Date and Time Picker" from infopath, resulting in a field which typically will appear as, e.g. "6/15/17 2:25:43 PM". My boss wants to keep this output as-is for our records, but does not want this field in the list view. Instead she wants a field that only shows the date (everything in the string before the first space " "). I am able to retrieve this in a report I've built by using the following SQL code DATEVALUE(LEFT(DateField,FIND(" ",DateField))) But when it comes to creating a workflow to populate a new field with this substring, I am at a loss. I've run several searches and the only SQL options for workflows appear to be the 'Utility Actions' (Extract Substring from End of String, Extract Substring from Index of String, Extract Substring from Start of String, Extract Substring of String from Index with Length) - none of which will allow the same SQL syntax I'm attempting since they only seem to want to accept integers or fields, not functions or even a " ". Is there a way to execute more complex SQL scripts within workflows outside of the Utility Action options OR a way to split a string based on a delimiter/accomplish what my boss is asking for (short of going back to infopath)?