InfoPath 2007 display date for multiple time zones

Hi-

I've seen several posts regarding submitting to a list using and InfoPath form which I am successfully able to do in limited form. (only passing a basic date value) My environment: MOSS 2007 Enterprise w/SP2, InfoPath 2007, SPD 2007.

I'm basically trying to recreate a calendar form with the same data elements (and some additional ones for a specific business requirement) as the standard calendar newform.aspx form. (start time, end time broken down by date, hour, minute and All day event)

I need the form users to be able to select the date and if it is not an All day event...be able to select the hours and minutes just like on the newform.aspx. (date picker control for date and drop downs for hour and minute selection)

On submit I then need to create the list item with the appropriate data passed via a workflow.

My Start Time has a validation rule to not allow dates prior to the current date (and it can't blank) The End Time has a validation rule to not allow dates prior to what is specified as the Start Time value. (Also can't be blank) When I attempt to include conditonal formatting to hide the hour and minute drop downs if 'All Day Event' is selected I get errors stating the fields can't be blank.

I also can't figure out how to pass the entire date/time values or the All Day Event to the list withou

Hello, Is it possible to use multiple sets of start and end times to have events display multiple times in a sharepoint calendar? To clarify: - I have the standard fields of "Start Time" and "End Time" in my calendar list. - Events show on the calendar just fine. - Would like to create additional fields called "Start Time 2" and "End Time 2" within the same record and have the event show multiple times on the calendar. - The recurrence functionality of sharepoint will not meet my needs because the pattern I need to use is not in one of the allowed choices. Thanks in advance, John

Hi AllI want to display time on Y axis and days on  x axis.I want to dispaly 12:00 AM,11:00 AM...11:59 PM.  on Y axis.I want function to create sequence like thatand on X axis display week like 6-sep,7-sep,..11-sep.can you give me the function for this.how i can create these

Infopath 2007 browser based form Full Trust Example: I have a repeating table (FruitChoice) that has multiple columns. Both drop down list point to sharepoint list data sources. Choose your tree ft. drop down list – 6Ft Choose your Department drop down list - 103 This repeating table is conditional on the drop down values. This works great. Trees     Fruit       Cost   Date Ordered    Date Delivery Department 6Ft        Peaches                                                        103 3Ft        Apples                                                          102 3Ft        Peaches         &

I have been working this issue for 2 days now.  This has happened to me in the past and I was able to work through it.  It doesn't appear that this time I am going to be so lucky. Issue Description: When publishing an InfoPath form a new column is created that has the same name as the correct one, but a new GUID is created. Troubleshooting steps: I have read this article: http://www.delphi-ts.com/blogs/lozzi/post/2009/06/03/Duplicate-site-columns-in-MOSS-from-InfoPath-Forms.aspx   This was the solution the last time I had this problem.  However, no matter what I do, it is not working now.  I have a column named User Name which is the username of the person that submitted the InfoPath form for use with my Visual Studio workflow.  When the workflow kicks off, it reads this column and attempts to get the value.  The value is blank because a new column with the name User Name now exists and that is where the value is stored.  I attempted to fix it by remapping the GUIDs as described in the article.  I also reverted the code to a previous version from TFS.  None of these worked.   I now have 3 columns called User Name and I can remap the GUID to the second column and third column.  But when I try to map it to the first column (the one I need) it doesn't work. The first column that is circled is the correct column. 

I have some Date fields defined in my sqlserver database but these display with a time part as well (00:00:00).

how do i esnure that only the date part is displayed and not this redundant time?

John 

Hi All,

I want to display 24 hours time and date in SSRS & for that I am using Format(now,"MM/dd/yyyy HH:mm:ss") but I am using this expression in Parameter, where I need to define datatype of that parameter as DateTime, not string. For Expression Format(now,"MM/dd/yyyy HH:mm:ss"), If I use DateTime datatype, It is showing error but working with String datatype.

For example:

I have parameter To Date  and value of this parameter should be 10/11/2010 13:09:16 (To Date: 10/11/2010 23:09:16) , not in AP or PM format and datatype of this parameter, want to keep DateTime that I can select value from Calender.

Please suggest me how I can achieve this?. I don't want to do it in stored Procedure side, want to do it in report side.

---

Thanks Shiven:)

I have an Infopath 2007 form with a multiple-selection box.  The form has a receive data connection to a Sharepoint custom list which shows software available to staff.  The form allows the user to select any number of items from the list of software.  I want to be able to show a summary list and more importantly print a summary of just the items from the list that were selected.  I want to be able to hand my IT person a list of the software that user needs installed.   I am trying to figure out how to get this summary list so it can be printed out.  Any help would be appreciated.

---

Renee Boyd

I’m developing an InfoPath 2007 form and need to give the current User the ability perform an AD search which will retrieve all AD entries with the same last name. I have successfully programmed the button event with the below code to retrieve a single AD user (first AD entry) using the DirectorySearch.FindOne method but have not been able to figure out how to get the DirectorySearch.FindAll method to work.

Does someone know how to tweak the below code to work for the FindAll method? Or, is the FindAll method the correct search method to use obtain the results I need?  

Try

 

   Dim xnMyForm As XPathNavigator = Me.CreateNavigator()

Date and Time Functions in SQLSERVER