Count the String for the current date

Question

1.00/5 (4 votes)

See more:

I have a certain values as "new , complete , inprogress , deleted" in table.
I need to count each string when there is a entry with respect to the current date.
Could any one help me..

Posted 30-Sep-14 11:51am

Hari-CodeBlogger

Updated 30-Sep-14 11:58am

v2

Add a Solution

Comments

Simon_Whale 30-Sep-14 18:19pm

is this in a generic collection or do you want to execute this against the database?

PIEBALDconsult 30-Sep-14 19:06pm

I hope you are storing dates as dates and not as strings; if not, you're hosed.

AndrewCharlz 1-Oct-14 2:44am

what is ur requirement or task

2 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)

Sinisa Hajnal · Accepted Answer · 2014-09-30T20:51:00

Note that this is for MS SQL Server - you didn't specify which database.
status is your field that contains new, complete, etc...

SQL

DECLARE @dt datetime
SET @dt = GetDate()

SELECT status, COUNT(*) FROM your_table 
WHERE your_date_field = CONVERT(datetime, @dt, 104)
GROUP BY status

Note that it would be better to have status table something like

PK        code        value
----------------------------
10        new         New
20        compl       Complete
30        inpr        In progress

I use code field if I need Enum names or some other no-user-needs-to-see-it task...while value is something to show the user. Number is used for combobox /radio button lists, sorting, etc...

Advantages are
a) you can easily sort by your integer primary key.
b) You can easily add in-between statuses if someone gets new idea.
c) You're not bound to exactly typing the word and worrying about case sensitive comparisons.
d) You can show your user whatever text you want without changing single line of code.

Disadvantage is that you have to link the table if you need the name (or write the function that returns the name for any given PK) - this is what I did :)

Hari-CodeBlogger · Accepted Answer · 2014-10-01T02:20:00

Solution 2

SQL

string strQury = "select count(*) from sqsh.view_smartopd where servicedisplayname = '" + strDocName + "' and tokendate = '" + dt + "' and value = 'new';";
           

countNew = rdr.GetInt32("count(*)");
txtTotalPatient.Text = countNew.ToString()

Posted 1-Oct-14 2:20am