Sorry to bump an old thread, but is there any way to do this without any code-behind?
What I'm trying to do is promote this field as a Date to a SharePoint Library. And what I'm hoping to do is filter out forms where this field is greater than or equal to [Today]-2. (In other words, I only want to see forms that are 2 days past this end date.
here is what I've got. This is the ONLY way, I can get the form to properly accept my datetime field without throwing validation errors.
My Form has a dataconnection to a web-service that is making a SQL call to a SQL 2K5 database.
Web-service call: "Select top 1 pe_end_date from pay_periods where active = 1"
And my field is equal to that value and is of datetime data type. And it properly accepts and formats the field. However when this gets promoted to my SharePoint list; it gets promoted as a single line of text and thus displays "2009-07-11T00:00:00-05:00" as the value.
Consequently, I cannot do any calculations on this field in order to filter by it. Can anyone give me any suggestions? Should I move this to SharePoint forum?