Logic to find out company business year ?

Question

1.00/5 (4 votes)

See more:

Hii ,

I am storing companies business data as month and date not storing any year.

based on date and month i want to find out companies current business year

for example if companies business year is set as 1 april then his current business year is as respective to current year is

2014/2015

any logic to find out this year data

I have date and month

Posted 21-Jan-15 20:24pm

Torakami

Add a Solution

Comments

Thanks7872 22-Jan-15 2:29am

Its totally meaningless. How on earth 1 april suggests someone that year is 2014/2015? Why not 2011?

Sergey Alexandrovich Kryukov 22-Jan-15 2:31am

Not storing any year? Congratulations! You lost year information. Good luck.
—SA

nagendrathecoder 22-Jan-15 2:34am

How can you identify this without storing year? It can be anything.

Torakami 22-Jan-15 2:38am

the logic is ... on today's date we can see that the companies business date is 1 and month is 4 , and todays month is 22-01 and April hasnt passed this year so its for past year i.e 2014 ...

jaket-cp 22-Jan-15 6:54am

What happens next year on 2016-01-22?
Should the returned year be 2015?

Torakami 23-Jan-15 0:11am

Yes on the year 2016-01-22 it will return 2015 because at that time my business month 04 and thats definately not for that year as its just jan going .. so it wiil return 2015 that means

jaket-cp 23-Jan-15 3:58am

okay, solution 1 appears to be good for your needs.
By the way, similar logic can be performed in SQL.

Torakami 23-Jan-15 6:46am

It would be appreciated if u can suggest

jaket-cp 23-Jan-15 7:12am

I have put up an SQL equivalent of solution 1.
Hope that helps out.

2 solutions

Solution 2

Here is a SQL equivalent of solution 1.

SQL

declare @testEndDateMonth int, @testEndDateDay int;
set @testEndDateMonth = 1;
set @testEndDateDay = 20;

declare @testDate datetime;
set @testDate = convert(varchar(4), datepart(year, getdate()))
						+replace(str(@testEndDateMonth, 2), space(1), '0')
						+replace(str(@testEndDateDay, 2), space(1), '0')
;
select 	
case when @testDate > getdate() then
	'Last Year'
else
	'This Year'
end WhatYear;

Posted 23-Jan-15 1:10am

jaket-cp

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)

George Swan · Accepted Answer · 2015-01-21T22:25:00

Solution 1

Is this the sort of thing you want?

C#

int testEndDateMonth = 1;
int testEndDateDay = 20;

//assume end date is in this calendar year
DateTime today = DateTime.Now;
DateTime testDate=new DateTime(today.Year,testEndDateMonth,testEndDateDay);
Console.WriteLine(testDate > today ? "Last Year" : "This Year");

Posted 21-Jan-15 22:25pm

George Swan

Comments

BillWoodruff 22-Jan-15 7:42am

+5 Looks good to me.

Torakami 23-Jan-15 0:10am

Thanks man , this will work for me ..

George Swan 23-Jan-15 0:54am

You are very welcome.