I'm having an issue working out how to implement this time based event. Basically, my program needs to send out an email at 12AM monday morning. But the email needs to go based on the user's local time not 12AM server time.
the problem i have discovered is Daylight savings. I used current server time as 12:00AM (my local time) and my actual offset is -7:00 UTC but after the calculation i get -6:00 utc because of daylight savings. If a user was in -7:00UTC then he/she will not get the email at 12am localtime but an hour late.
I am adding a custom header to a SharePoint master page and I would like to display the current time in four different time zones. However, I don't want to use the client's time as there is no way to know what time zone the client will be in, or if they have the correct time on their computer.
I need the clock to update as each second changes. So it is a live time instead of a static time.
This is the code I'm using.
<script runat="server"> Sub Page_Load(ByVal Sender As Object, ByVal E As EventArgs) End Sub Public Function dtBase() As Double Dim d1 As Date = New Date(1970, 1, 1)
Still don't know if the code worked. My SharePoint server rejected the page for the code blocks. I have absolutely zero idea how to do code-behind. The JS works, but if the client's time is off, the site displays incorrect times. Really wish I could just code this in PHP. I'd be done a week ago. ;)
This update is for anyone that stumbles across this in the future looking for the answer to the problem. The code above has been updated to work correctly. The only catch is that SharePoint disallows code by default, so to enable it, you have to modify the web.config file. The web.config file is usually in the root directory of the site. Inside that file (which is XML), you'll find a tag. Somehwere inside of that, you should find , and inside of that, you should find . Inside of that tag, you want to add this:
I'm writing a class to automatically extract information from an excel spreadsheet (using NPOI api) in C#, and then import this information into a database. I've got it all working fine except for one small issue.
One of the spreadsheets I'm working with, contains the date in the following format: 04/01/2011 04:43:28.
When I ran the web application, I got the following error message:
String was not recognised as a valid
So I debugged through the code after this, and it turns out that the date is being read in as:
40546.0151388889, so it is being formattted back to a number.
i am displaying some news from rss feeds in the page. But i am stuck up in the date time conversion. I got th published datetime as pdt formated string. How can i convert to my local time. Coversion from the pdt string tot DateTime is error..
This second line is error and i need the result in the specified format or same format as in the published date but in local time ie IST (India Standard Time)
Our business case requires that a Start Time and End Time must be defined for each Organization involved in the business model. For example; some organizations have their working hours from 8:00AM to 5:00PM and others from 9:00 to 6:00PM. While creating a new Event on our calendar these should be queried from the database (StartTime and EndTime) and setting these as default. My questions are:
1) How should I save these times since DateTime requires a Date in front of it and there's no Time column format on SQL Server (Varchar? Number?). If using one of these types how to I concatenate these to a DateTime variable?
2) If the column should be DateTime, how do I concatenate it to replace the column's Date with Today's date and replace the Time with the time specified for that? Let me be more clear:
Default values saved in the database: StartTime = "2010-01-01 8:00AM" EndTime = "2010-01-01 5:00PM" In my code after querying, my local variables would be populated and replaced by: OrgStartHour = "2010-03-26 8:00AM" and OrgEndHour = "2010-03-26 5:00PM"
The code above works but I have no idea on how to replace/concatenate the "2010-01-01" with today's date while keeping the "8:00 AM" on it. :)
I have deployed my asp.net application in my hosting provider they are from US... I have one filed in which i have wriiten Datetime.now.tostring() it saves in Database table it save 11/11/2010 5:20:47 AM
We have a generic site which we deploy to clients and they personalise the text using the web parts. The problem we are currently experiencing is that they are unable to move web-parts between zones. This is not a JS issue as no errors are being thrown and this is not a CSS issue either, as we re-deployed the website here on our own server and it works perfectly fine. On our client's site, we can drag parts around in the zone it is in, however when we try to move a part out of that zone, we are given a circle cursor with a line through it. Adding parts to a zone is not an issue.
This could perhaps be linked to a previous issue of being unable to view any editable parts of a webpart. I resolved this by removing all the WebPersonalization from the WebPersonalization table in our MSSQL database.
I would like to achieve a nice smooth transition when the user moves controls between the WebPartZones similar to how iGoogle implements it. I've not yet been able to achieve this - the transition is very jumpy and not very smooth (I cannot use SilverLight).
Has anybody achieved this using WepPartZones without the use of SilverLight?
I have a WebPartZone in each of two adjacent columns. There is a gap of about 4 pixels between the two columns that I cannot remove.
I have two zones with the following markup:
On running the page, the relevant source code is:
<%-- End of contents and div containers for Column 1 Zone --%> ...jText at the end of this Webpart.</span> </td></tr></tbody></table> </td></tr></table> </td></tr> <tr>td style="padding:0;height:100%;"></td> </tr></table> </td></tr></table> </div> </div> <%-- Start of div containers for Column 2 Zone --%> <div id="ctl00_Main_MainCol2" class="box33" style="Width:39.9%;"> <div id="ctl00_Main_MainCol2Con" style="width:auto; margin-left:0.0em; margin-right:0.0em;"> <table cellspacing="0" cellpadding="0" border="0" id="ctl00_Main_ZoneCol2"> <tr><td style="height:100%;"> <%-- The following 2 tables both have cellpadding="2" which appears to be causing the problem --%> <table cellspacing="0" cellpadding="2" border="0" style="width:100%;height:100%;"> <tr><td> <table cellspacing="0" cellpadding="2" border="0" id="WebPart_wp1787670866" style="width:100%;"> <tr><td cellpadding="0" style="padding:0px;"> <div id="ctl00_Header_WebPartManager1_wp1787670866"></div> <%-- Start of contents of Column 2 Zone --%> <table cellspacing="0" cellpadding="10" style="border: thin solid #000000; background-color: #8db3e2; width: 100%;"> <thead> </thead> <tbody> <tr> <td><span style="font-size: 12px;">Text at the beginning of this WebPart....
Two of the tables, which I think are rendered by the WebPartZones, have cellpadding="2". This seems to be giving the 4 pixel gap between the columns.
Sometimes I get a datetime with a time sometimes it's just the date. Of course if it's just the date I I want to format with "dd.MM.yyyy" and if it has a time "dd.MM.yyyy HH:mm".. This is in a repeater, so I thought may be it's possible without a simple if statement?
i have two clock times in my DB as varchar datatype.. i loaded it from db as varchar itself. in C# i have assigned this value to a datetime variable.. how can i get the time from the datetime variable without changing it into a string.
I have a datetime column where I store the amount of time a person workded on a project, so it might be 2011-02-16 05:00:00.000 in the column, this being 5 hours. I need to get a sum of the hours in my sproc I tried
I have a DateTime stored in UTC time that I'd like to display to the user in their local time from within a GridView control. How can I convert my DateTime to the user's time (not my server's local time)? Here is my current field as it appears in the GridView Columns collection: