InfoPath + Sharepoint Calander View - InfoPath Dev
in

InfoPath Dev

InfoPath + Sharepoint Calander View

Last post 06-28-2007 03:53 AM by fastie81. 3 replies.
Page 1 of 1 (4 items)
Sort Posts: Previous Next

  • 06-27-2007 06:22 AM

    InfoPath + Sharepoint Calander View

    Reply Contact

    Hi

    I Have this problem with InfoPath, Got a Start and End date(Date only) that I want to display in a calender View on Sharepoint. But the end day is not included. What I have worked out so far is that it is relating to the time. Even if you just selected the date only, in the XML form it will have it as yyyy-mm-ddT00:00. Now I tested this by changing it to desplay the date and time and changing the time to 23:59 of the day I selected and then it shows correctly in the calender. However I want to avoid asking the user to put in the time on the end date. So the only way I can think of doing this is by changing the time in code. But I don;t know how to do it in code. I have been searching the web for the last 2 days and have found nothing. Does any of you guys know how to get around this problem?

    I am happy to send my form on for you to have a look if need be.
    Thanks

  • 06-27-2007 02:37 PM In reply to

    Re: InfoPath + Sharepoint Calander View

    Mark as Answer
    Reply Contact

    If what you are asking is to change a date from 2007-06-27T12:00:00 to 2007-06-27T11:59:00 this can be done pretty simply with a rule.

    On your EndDate field have a rule that sets a field value as the action. lease the condition blank so it happens each time it is changed.

    Select EndDate as the Field.

    Set the Value

    insert the function concat(substring-before(enddate, "T"), "T", "11:59:00")

    This will take the date, remove the existing time and insert the time you want.  This may not be exact syntax, since I am just writing it out from memory, but should be close.

    Clay Fox / Microsoft InfoPath MVP

  • 06-28-2007 03:20 AM In reply to

    Re: InfoPath + Sharepoint Calander View

    Mark as Answer
    Reply Contact

    Hey

    Thanks . I will give it a go and let you know.

     

  • 06-28-2007 03:53 AM In reply to

    Re: InfoPath + Sharepoint Calander View

    Mark as Answer
    Reply Contact

    Hi

     

    Ok I tested this and it work great. Thanks you so much..

    I had to change the thing to date and time and just hide the time from the end user. but after that is work.

    Thanks again

     

     
Page 1 of 1 (4 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.