Arithmetic Operations on DateTime Datatype.

Question

2.50/5 (2 votes)

See more:

Hi,

I have been trying to find a way to do Arithmetic operations on C# DateTime datatype variables but I couldn't get any,
My Requirement is to Generate weekday index from given Date(//Monday =0)
in VBA I can get this Directly By:

VB

Dim WeekDay as Integer
Dim NewYear As Date
NewYear = DateSerial(2009, 1, 1)
WeekDay = NewYear Mod 7

But There is no such functionality provided in C#, to do operations on DateTime variable with Other Datatype variable.

Is anybody have idea, is it provided in C#!!?, why it is not?

-Trinadh

Edit: Code formatted.

Posted 8-Sep-11 16:39pm

trinadh.ch

Updated 8-Sep-11 18:27pm

Mohammad A Rahman

v4

Add a Solution

Comments

BillWoodruff 8-Sep-11 23:22pm

There certainly is this functionality in C# ! Why haven't you looked at the DateTime Type in C#, and examined its methods ?

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Roger Wright · Answer 1 · 2011-09-08T18:46:00

Solution 2

I suggest that you take a look here[^]. This is the documentation for the System.DateTime class, which includes methods for manipulating dates.

Posted 8-Sep-11 18:46pm

Roger Wright

Ganesan Senthilvel · Answer 2 · 2011-09-08T17:39:00

DateSerial is not part of C# .NET. Reasons are:

1. Originally DateSerial is a VBScript function as referred:
http://www.w3schools.com/vbscript/func_dateserial.asp[^]

2. The 5 digit DateSerial value is specific to Excel; I know of no class in the .NET API that is going to provide the same value.

Still, itz achievable through Excel's DateValue access through C# using .NET Excel Interop funtionality.

skv_lviv · Answer 3 · 2011-09-08T19:03:00

Have you tried DayOfWeek property? http://msdn.microsoft.com/en-us/library/system.datetime.dayofweek.aspx[^]

It returns enum, which can easily be converted to int. The only problem is that it starts with Sunday = 0, but I can substract 1 and replace -1 with 6 if you want to start from Monday.

Arithmetic Operations on DateTime Datatype.

3 solutions

Solution 2

Solution 1

Solution 3

Add your solution here

Preview 0