SharePoint Stack Exchange
SharePoint Stack Exchange

Questions tagged [date-time]

Represents an instant in time, typically expressed as a date and time of day.

Represents an instant in time, typically expressed as a date and time of day.

Questions tagged regards all aspects of the use of a specific time in SharePoint.

Reference: DateTime Structure

551 questions
2
votes
1 answer

Calculated Column that will trigger the word "expired" in another column

I am looking to create a calculated column that will trigger the word "expired" in another column if the date is less then or equal to today's date. Do you know what formula I would use for this?
vier111
  • 145
  • 2
  • 10
2
votes
1 answer

Create a Datetime from Modified with Static Time

I have a need to create a Calculated Column that is a Datetime based upon [Modified]-1, but with a static time of 11:59:59 PM. Something like this: =DATE(YEAR([Modified]-1), MONTH([Modified]-1), DAY([Modified]-1), HOUR(23:59:00), MINUTE(23:59:00),…
Joe Fedorowicz
  • 355
  • 2
  • 14
2
votes
1 answer

How to set the date on the DateTimeControl on SharePoint 2010?

Want to enforce the Users to select only Friday. As it does not seem to possible, would like to set programmatically when user selects the date. It works fine behind the scenes however on the browser it still shows the selected date than Friday. …
Karthikeyan
  • 2,548
  • 14
  • 82
  • 142
1
vote
0 answers

Date and time in SharePoint News Archive List

I have the following method which gets the old news items and displays in the archive page. I am displaying the old news items by month wise. User will click the Month URL and then he can see the available old news items in an archive page.…
Ram
  • 439
  • 7
  • 18
1
vote
1 answer

Alert based on due date

I am looking to create an alert to a user based on approaching a due date. example, Mr Jones (the doc owner) will get an alert 30 days before his document needs to be reviewed. I have looked through the built in features and don see how I can make…
King Dado
  • 11
  • 1
1
vote
0 answers

Set Due Date using a Workflow for a date 2 days after the item was created

Running into trouble using Designer. I need my workflow to set the due date for 2 days in the future but it will only let me set today's date or a specific date as the value.
justin
  • 11
  • 1
  • 1
  • 2
1
vote
2 answers

Validate SharePoint date time control

I have two fields; one is normal text box used to generate system current date and the another field is I need to validate this two: the date selected in SharePoint datetime control is not less than the date generated…
chiranjeevi Avala
  • 23
  • 1
  • 9
0
votes
1 answer

Update a date field when Title field is changed from blank in SharePoint 2010

I have a list where items are created with control numbers at project kickoff. I need to have a date field update when the column "Title" is first changed from blank to text. This field should never change. Can I do that with html code or out of the…
rmcfarron
  • 1
0
votes
1 answer

Date Time ins LIST

I Have a list (Orders list) where i have a column "CreationDate" as internal name. That column stores datetime of the order. When I show this column in a View, it appears in the format "dd/mm/yyyy" and that is good for me. The problem comes when I…
JulianoG
  • 161
  • 1
  • 4
  • 15
0
votes
2 answers

GetFieldValueAsText DATE plus 1 hour

I have a GetFieldValueAsText converting DATETIME with 1 hour plus: 29/01/2014 14:26:45 after GetFieldValueAsText I get 29/01/2014 15:26 Someone can help me? Thanks
JulianoG
  • 161
  • 1
  • 4
  • 15
0
votes
2 answers

Showing only last six months in a dropdown

I have a month column (a choice column) in my document library. Its format is, for example, "Jan 2013". I have the following requirements: The month dropdown should always show only the previous 6 months relative to the current month. For example,…
nivi
  • 3
  • 1
  • 3
0
votes
2 answers

Saving date on sharepoint profile

I have a method on my code that stores the birthday of users on a Sharepoint profile property (BirthDay). This property only accepts the format "yyyyMMddHHmmss.0Z" so i have the following code: _profile[PropertyConstants.Birthday].Value =…
C. Hoffmann
  • 625
  • 2
  • 6
  • 20
0
votes
1 answer

Capturing Multiple Time Zones in Sharepoint

I need to capture multiple time zones in our Sharepoint site. Ideally I would like to enter AEST and have the other files calculate/convert to the various other timezones. Is there a way I can do this? I know about the calculated option in the field…
Toni
  • 1
0
votes
0 answers

Calculate weekday from 02 date columns (included time) then return value at least 0.5 day

I'm practicing on Sharepoint and have an issue which looking for your guide: On sharepoint list, how can to calculate 02 [date & time] columns then return value should be at least 0.5 day as calculated unit. For detail: StartDate: 6/14/2023…
Delli
  • 1
  • 1
0
votes
1 answer

Calculate dates between now and a specific date

I am trying to have a calculated item between two dates. What I am hoping to do is, get this item to calculate the date difference between now and another date (provided by the submitter) I tried =DATEDIF(TODAY(),[Start Date in Current Role], "D")…
Baris Ozuunlu
  • 1
1
2