locked
Converting/Translating Date Time to Date RRS feed

  • Question

  • I have a Date Picker field which I want to pre-populated from a SharePoint List.... But it pre-populate the Date field field in infopath with 2011-05-21 00:00:00 which I want to convert to just 2011-05-21 ...as other wise it gives a Validation error on Infopath...

    Let me know if anybody has any idea if I could do soemthing here...

    Thanks in Advance

    Friday, March 4, 2011 10:11 PM

Answers

  • Use substring-before(DateValue, " ").  Not that there is a space between the quotation marks, and "DateValue" is the field you're referencing in the SharePoint list, which I assume is being found with a filter, so it may look different than what I typed.
    SharePoint Architect || Microsoft MVP || My Blog
    Planet Technologies || SharePoint Task Force
    • Proposed as answer by Parvez Akkas Saturday, March 5, 2011 1:36 AM
    • Marked as answer by David HM Tuesday, March 15, 2011 1:06 AM
    Friday, March 4, 2011 10:38 PM