Access 2007 + c# Data rank

Question

1.00/5 (1 vote)

See more:

hi i have problem with Data format
i try to select i rank of 2 data
i try this format of data
yyyy/mm/dd
mm/dd/yyyy
dd/mm/yyyy
but no one of this is universal for all windows machin
can some one suggest me how is the best format ?thnx

Posted 16-Apr-12 8:00am

nika2008

Add a Solution

Comments

Nelek 16-Apr-12 16:44pm

Nika, I have moved your message to a comment for chris. Please don't write answers to speak with someone that proposed you a solution. The correct way to do it is using the "improve question" if you want to add information about the problem or the button "have a question or comment?" to speak directly with the person you want (as I am doing right now with you and as I did with your comment to Chris)

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)

Chris Ross 2 · Answer 1 · 2012-04-16T08:15:00

If you're doing the sorting in the access database, you should be using a DateTime column type, and the database will take care of proper sorting for you.

If you're doing the sorting in your C# app, the DateTime structure has comparison operators that you can use to rank order dates.

You should use this structure, not strings, for comparing and sorting dates.

If you are displaying dates in a column in a list or grid, then it is likely that you can configure the grid to accept DateTime objects in that column (i.e. you do NOT need to convert the DateTime to a string; in fact, this may be done automatically for you). The grid will likely have a means by which you configure what part of the DateTume is actually shown to the user, and how it is formatted, but, behind the scenes, the grid knows that the datatype stored in the column is really a DateTime and therefore knows how to sort it properly.

The bottom line: only convert dates & times to strings at the very last minute; do all computing using a strongly typed variable before converting to a human readable form.

Hope that helps,
Chris

Wes Aday · Answer 2 · 2012-04-16T09:18:00

Solution 3

SQL

select *
from tabel
where tabel.data >= #dd/mm/yyyy# AND table.data <= #dd/mm/yyyy#

use BETWEEN to get data between dates.

SQL

SELECT *
FROM tabel
WHERE tabel.data BETWEEN #dd/mm/yyyy# AND #dd/mm/yyyy#

Posted 16-Apr-12 9:18am

Wes Aday