Exclude calendar holidays from rrule before processing

I am using the rrule method from dateutil-python package. I would like to create a rule that can ignore dates that are within a holiday calendar. I know about the exdate() method but this seems to filter the date from the output list only it has been generated. from dateutil.rrule import * from datetime import datetime set = rruleset()...

DateTime picker in Asp.net

I am beginner of asp.net.I want to show date and time picker.I googled many times but not getting any thing.I download the files from the "keduoi.com" and used in mu project but its not working property showing only textfield. I am trying from here here is code: <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="LaterTime_Pick_up.a...

Calculate age with DateTime [duplicate]

This question already has an answer here: How do I calculate someone's age 36 answers Calculate age with DateTime in C# ? DateTime a person birthday, may i know how Can I calculate his age? DateTime today = DateTime.Today age = today.Year - bday.Year; if (bday > today.AddYears(age)) age-;...

Autofac: how to inject properties with dynamic values?

By Autofac, it's easy to inject a static value to the CurrentDate property to instances of classes in a given assembly: builder.RegisterApiControllers(asm).With Property("CurrentDate", new DateTime(2012, 1, 13)); However, how to inject dynamic values e.g. values returned by a lamda () => { return DateTime.Now; } to the CurrentDate prope...

Convert a Date from mm/dd/yyyy to dd MMM yyyy

How Do I convert a datetime from mm/dd/yyyy to dd MMM yyyy? DateTime.ParseExact or DateTime.TryParseExact does not require a parameter that tells it what format I want it in. So how does it know that I want it to return the passed in date to dd MMM yyyy format? DateTime result; var dateTime = DateTime.TryParseExact("03/21/2013", "mm/dd/yy...

Getting hours occupied in a day

Say I have a variable DayHours and a DateTime called CurrentDay I have events with a start date, an end date, and hours. They all fall within CurrentDay If it is the last day of the event and the end date == CurrentDay , then I need the remainder. So if a day lasts 5 hours and an event is 14 hours and today is the last day, I would retu...

Chart hiding empty values

I have a candlestick MS Chart (Framework .NET4). I have DateTime in abscissa (X), and sometimes for a X value, there is no Y value. How do I not display these X values? How do I not display empty candles? To be clear, I don't want a linear X axis.

Operator overloading for Type

When I was typing the question I could see list of Operator Overloading... questions lined up. Most of them are either for C++ or Haskell. My question is for C# and one could say the logic could be the same. And my problem is I want to understand operator overloading in C# context. I was looking at a tutorial and it shows, DateTime dt1 =...

Need help: Difference between sum of values with data in one column with adjacent column

Hi All, I have two columns A and B as shown below with 12 values(A1-A12 and B1-B12) Code: 20.0 21.0 20.0 22.5 20.0 23.0 20.0 20.0 20.0 20.0 18.0 18.0 16.0 16.0 15.0 Now In A14 i need a formula, which will 1. Get the sum of cell values in Column B and Sum of Corresponding cell values in Column A Column B = 21.0+22.5+23.0 = 66.5...

Sort Date time only by start date

I have already asked a different question regarding Sorting Date Time and got help from another user to pass my values. I am using a for loop like below, but definitely am wrong here because the code brings the value one by one rather than sorting. public class Break public DateTime MealStart { get; set; } public DateTime MealEnd { get...

determining which hours in multiple days have non-NA values

I have a data frame with three columns: DATE, HOUR, HRC (So there are 24 rows for each DATE) The HRC column is sometimes a number and sometimes NA. I am trying to figure out a way of taking a subset of DATEs and then figuring out the HOURs that have non-NA values across all days. Example: so if DATES are Aug16, Aug18, Aug19, and HRC colum...

Powershell - Getting a persons age

I'm trying to get a person age in Years,Months,Days,Hours,Minutes and Seconds. This is what I got so far (you can tell I'm a total powershell beginner): $now = [datetime]::now [datetime]$birthday = "12/22/2012 03:22:00" $age = [datetime]$now - $birthday Write-Host "My daughter's age is:" $age.Days "days" ($age.Hours) "hours" ($age.Minutes...

how to get java class object values in jsp

I have a java class Main.java where I'm calculating the Sum and Difference in the variable like int sum = a+b; int diff = a-b; and are are the values which are coming from the database through Hibernate. now i want to Display the sum and diff values on a JSP. please Help me out to bring sum and diff values from java class Main.java to...

Highcharts chart not showing in IE9

i have made a Time Series chart with highcharts. It works fine with FF, but it doesnt run in IE9. What could be the probleme here? http://jsfiddle.net/sbra/tcFju/ Full code on jsfiddle: Snippet here: $(function () { $(document).ready(function() { var jsData = JSON.parse('{"data":[{"dateTime":1035151 200001,"value":0.737},{"dateTime":135...

AChartEngine: set x values in RangeBar chart series

My aim is to display a RangeBar chart together with a timeChart in a CombinedChart view. Both series show information about the same time interval. My problem is that I can't define the x values of the RangeBar chart. So it's values are shown all nearly 0 on the x-axis while the TimeSeries begins e.g. on value 100000 on the x-axis (DateTi...

#0239 - SQL Server 2012 - Msg 402 - The data types datetime and time are incompatible in the add/subtract operator

Microsoft SQL Server 2008 came with a wide array of T-SQL enhancements. One of them was the ability to split a DATETIME value into DATE and TIME values. From a storage standpoint this allowed us to store and bind (on the UI) date and time values separately, while appending the values when displaying on a report or exporting to a 3rd pa...

JavaScript Json.stringify replacer converts values to string

I am using the javascript JSON.stringify function with a replacer (second parameter) to format date values in a certain way: var s = JSON.stringify(data, function (key, value) { if (key === "") return value; if (jQuery.type(value) === "date") return "Date(" + value.getTime() + ")"; return value; }); I have valid datetime values in my...

c# check if daterange between an interval

I need some clear mind to check if a date range false between another interval. Here is whats happening: DateTime[] dates = new DateTime[20]; dates[0] = Convert.ToDateTime(initial_date); for (int i = 1; i <= 19; i++) dates[i] = initial_date.AddYears(i); So i have an array that stores 20 dates. If the initial_date = 1/20/2012 the array...

The string was not recognized as a valid DateTime. There is an unknown word starting at index 0

I have the following C# that is giving me the error above when trying to parse string to datetime. DateTime backupdate = System.Convert.ToDateTime(imageflowlabel .Text); DateTime currentdate = System.DateTime.Now.AddHours(-2); int result = currentdate.CompareTo(backupdate); imageflowlable.text looks like this 2012-04-15 15:23:34:123 Any...

From database to datetime picker

I have a form with few datetime pickers, to be exact two pairs of dates and times. Data from those pickers is combined and saved to database as DateTime in format 16/05/2012 11:28:00 a.m. Now, what I want to do is get value from database and put it into datetime pickers. I've tried something like string plannedDate =(dbFunctions.SQLReadC...

DateTime?.ToString(format)

got issue parsing DateTime? to specific format. Like: DateTime t1 = ...; string st1 = t1.ToString(format); //<-- works DateTime? t1 = ...; string st1 = t1.ToString(format); //Dont work. Theres no overload method for DateTime? Solved. Thanks...

DateTime Conversion and Parsing DateTime.Now.ToString("MM/dd/yyyy hh:mm:ss.fff")

I store some DateTime in a CSV log with: DateTime.Now.ToString("MM/dd/yyyy hh:mm:ss.fff") When I try to read it i found something like: "05/15/2012 10:09:28.650" The problem is when i try to cast it as a DateTime again... DateTime.Parse("05/15/2012 10:09:28.650"); Throws an Exception "Invalid DateTime" or something like that... How can I...

Correct a function to declare a winner as soon as possible

I'm making a tic-tac-toe game. How would I change the following code so that the winner could be declared before complete is true, (every square filled) and the winner is the first to achieve 3 matching values, not the last to achieve it? function check_squares () { var values = new Array(); var complete = true; $('.square').each(funct...

Convert DateTime to Swatch Internet Time (Beat time)

I was searching to convert DateTime to Swatch internet time in C#. I did not find anything. How do i convert DateTime to beats? EDIT: Found the solution, will post it as answer soon: var time = DateTime.Now; //get the current time var utc1 = time.ToUniversalTime().AddHours(1); //convert the given DateTime to universal time and add one hou...

DateTime conversion - server

I've declared my DateOfBirth property as string and am parsing it to DateTime before passing it to the database, coz the DateOfBirth column is in DateTime format there. in my local system, the conversion is working fine, but after hosting the application to the server, the DateTime conversion showing error like "string was not recognized...

Don't Serialize, or Remove, TimeZone from Serialized DateTime objectes

The odd task that I have been given is to serialize a LARGE object using XML Serialization. This object contains multiple Nested UserDefined classes, with multiple DateTime fields. The Requirement for the DateTime data is that it must ALWAYS be displayed in the TimeZone of the user who initially created and set the data. Thus, I Cannot us...

Get Date difference between a date and datetime fields using "Floor"

I am trying to get number of day differences using Floor function between a date and a datetime field. But i am getting one extra day. This is how I`m doing-> SELECT col,col1,FLOOR(col-col1) FROM tab_name Here col is just Date field,Col1 is DateTime Field Any idea?...

Error: The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value

I know that there are simmilar questions like this on the forum, however I am still having problems to update a datetime field o the database. I dont get any problems when inserting but I get problems when updating and I am formating the same way , like this: e.Values.Item("SelectionStartDate") = Format(startdate, "yyyy-MM-dd") + " " +...

Manipulating DateTime and TimeDelta objects in python

I am wondering how to manipulate Datetime and Time delta objects. I am writing a game where different planets have different timescales. And I was wondering how it might be possible to mod datetime objects. For example if I have a date time object - some past datetime object I was wondering if it was possible to know how many times 6 hour...

Get number of days from DateTime::Span

I have a set of time ranges and need to get the Number of days from this set. I did it with DateTime::Span as follows: use DateTime; use DateTime::Span; sub printHash { my $hash = shift; foreach my $key (keys %{$hash}) { print "$key: $hash->{$key}\n"; } $date1 = DateTime->new( year => 2002, month => 3, day...

MVC Model Range Validator?

i wnat to validate the datetime, My Code is: [Range(typeof(DateTime), DateTime.Now.AddYears(-65).ToShortDateSt ring(), DateTime.Now.AddYears(-18).ToShortDateSt ring(), ErrorMessage = "Value for {0} must be between {1} and {2}")] public DateTime Birthday { get; set; } but i get the error: An attribute argument must be...

Finding Difference of 2 sets in Java

I have two hashsets in Java, of which I want to find the difference I tried the following code as recommended by Oracle's doc HashSet<RunningTaskInfo> difference = new HashSet<ActivityManager.RunningTaskIn fo>(newRunningTasks); HashSet<RunningTaskInfo> oldRunningTaskInfos = new HashSet<ActivityManager.RunningTa...

Deserialize Json DateTime with time zone

I'm doing this for two hours and nothing. This is the date in Json: "\/Date(1330355834000+0100)\/" Everything I found was withouf=t timezone or for JavaScript. How to convert it to DateTime (not Date)?...

C# - SqlDataReader - How to get nullable DateTime out of the database

My SQL Server database contains nullable DateTime values. How can I convert them to a nullable DateTime object in my application in C#? This is what I would think it would look like, but it doesn't: DateTime? dt = (DateTime?) sqldatareader[0];...

date difference between two dates

I want to calculate the date difference between form date and two date..Am using timespan to calculate the difference between two date if date difference is positive means it enter another process falls means it return error message. My partial code is here.. TimeSpan span = Convert.ToDateTime(txtenddate.Text).Subt ract(Convert.ToDateTim...

When storing a datetime in sql server (datetime type), what format does it store it in?

When storing a datetime value in sql server 2008, using the datetime type, what format will it store the value in? Is it the number of seconds since 1970 (or whatever)? On the application side (.net), I am passing in a datetime object. When I view the table's rows in query analyzer, will it format it according to my culture settings or am...

Showing Difference between two datetime values in hours

I am retrieving two date time values from the database. Once the value is retrieved, I need the difference between the two values. For that, I create a timespan variable to store the difference of the 2 date values. Timespan? variable = datevalue1 - datevalue2; Now i need to show the difference which is stored in the Timespan variable in...

NHibernate Unable to convert MySQL date/time value to System.DateTime

I am getting the "Unable to convert MySQL date/time value to System.DateTime" error because from what I can tell I have a record with 0000-00-00 00:00:00. Now while the data should never be that (it should be null) there are cases when this might happen and I don't want my entire application to crash because of it. I am using NHibernate a...

What's the best way to parse an XML dateTime in Java?

What's the best way to parse an XML dateTime in Java? Legal dateTime values include 2002-10-10T12:00:00-05:00 AND 2002-10-10T17:00:00Z Is there a good open source library I can use, or should I roll my own using SimpleDateFormat or similar?...

DateTime - C# под Web, ASP.NET

Здраствуйте подскажите код для сравнея двух дат. Код: DateTime date1 = new DateTime(0,0,0,0,6,0);// ошибка DateTime date2 = new DateTime(0,0,0,0,20,0);/Ошибка int result = DateTime.Compare(date1, System.DateTime.Now); int result1 = DateTime.Compare(date2, System.DateTime.Now); if(result >0 & result1>1) Response.Redirect("~/WebForm1.