View Complete Post
I have a little question about settings specific today (Date + Time) value to a field/column within a workflow that is designed by Sharepoint Designer 2007.
I can manage to set the field to today() => but the time is always 00:00 houres.
I would like toÃÂ set a specific field to the "exact" date+time when the workflow is running. (so choosing a fixed date+fixed Time isn't a solution either)
So I anyone could help me how I can do such "simple" task, I would be very pleased.
I have a 2010 Record Center. Indexing and search functions seem to be working. However dates do not appear in search results. The column is marked for indexing. Crawling is working and I do get other text type results. I have
tried switching the column to Date & Time in the detailed column settings. With or withouth the time, it does not come up.
There is an interesting twist. On SOME, the search returns the AllItems.aspx PAGE (not the documents) with the date highlighted in the result item description.
I am using Sharepoint 2007 Enterprise edition.
I have two columns called Start Date and End Date (both of datetime type). These columns are used to maintain start date and end date of a contractor in a company. I have a calculated column (called Status) which displays "Active" or "InActive" depending
on the below mentioned conditions.
I used this formula :
=IF(OR(OR(AND((Today>[Start Date]),[End Date]=0),AND((Today=[Start Date]),[End Date]=0)),OR(OR(AND((Today<[End Date]),(Today=[Start Date])),AND((Today<[End Date]),(Today>[Start Date]))),AND((Today=[Start Date]),(Today=[End Date])))),"Active","InActive")
This is working but not updating the value correctly. I think Today value is not getting updated dynamically.
I have 5 conditionds:
1. Start Date < Today (Where End Date =0)
or Start Date = Today where (End Date =0)
or Start Date < Today < End Date
or Start Date < Today and Today = End Date
or Start Date < Today and End Date > Today
Any help is appreciated.
Thanks in advance.
I created new column in list - Date and time (Date and time format: Date&Time, Default value: Today's Date)
The problem is, when I create new item in list, the default time is always set as next full hour, eg. now it's 13:15 or 13:31 ora 13:57 and in aspx form it's all the time 14:00. Obviously, I can change that date with 5 minut precision (13:05, 13:10, 13:15
etc.), but it's kind of annoying.
when am copying a date column from list A to List B.
am able to copy the the date but, copied date has date decreased by a day!
after coping to
Date = 11\25\2010
if (properties.AfterProperties["follow_x0020_Date"] != null)
item["Status follow up date"] = properties.AfterProperties["follow_x0020_Date"].ToString();
flag = 1;
dt = Convert.ToDateTime(properties.ListItem["follow_x0020_Date"]);
I have one issue in creating a calculated column formula:
The idea is:
| Column1 | Column2 | Column3 |
| Name1 | (empty) | Name1 |
| (empty) | Name2 | Name2 |
| Name3 | (empty) | Name3 |
For example we have 2 columns (Column 1 and Column 2) that may have or may not have a value but at least one of them will have a value.
Column 3 is the calculated column that will check if Column 1 has value and Column 2 is empty(by default Column 2 will be empty because Column 1 has value :)) then the value in Column 3 will be the same value as Column 1. Otheriwse if Column 1 is empty and
Column 2 has a value, the Column's 3 value will be the value from Column 2.
I'm in the process of migrating from a WSS 2 site to WSS 3/MOSS. On the old site I used an Infopath 2003 form for absence requests. During the migration I now use Infopath 2007. There wasn't any problem initially when the form was stored with the SharePoint form library. However, when I published the form as a content type from Infopath 2007 and then added that content type to the form library, there are two columns for each piece of data from the form. (One from the content type and one from the form list.) I relinked each old form (list content type) to the new AbsenceRequest content type and removed the original one from the list. However, the duplicate column names are still there. Since they came from the Infopath form, they are not editable or deletable from the SharePoint list management interface. The duplicate column names make it tough to build views since it isn't apparent which column to use in the form building UI. It can be determined form the overview display, but it is very cumbersome.
Does anyone know a way to get rid of the old, absolute, columns?
I have a sharepoint list[Managers] with groupby sector column. like below
Each Sector group by column data i want to display in label or panel control.
How to do that ? how to write the logic?
I found many examples such as this which is completely wrong. In the example below the [Today] is only calculated on item creation and edit, not every time list item is accessed.
This is very important my customer wants it done asap.