Data base record show According to Date

Question

0.00/5 (No votes)

See more:

Hi, i have one table name Ageing and there are many rows like CustCode,Date,BillPayment,ReceiptPayment,Due and i want to show all records like this formet
CustomerCode,BillPayment,ReceiptPayment, <30Days,30-60Days,60-90Days,90-180Days,Due...

Posted 4-Dec-11 22:46pm

Member 8357723

Add a Solution

Comments

[no name] 5-Dec-11 4:48am

can you give us your desired output?

Member 8357723 5-Dec-11 5:07am

CustomerCode Date ReceiptPayment BillPayment Due
ARKNMI 22/9/2010 19800 477 19323
ARKNMI 22/9/2010 19323 21 19302
ARKNMI 18/10/2010 19302 1204 18098
ARKNMI 17/11/2010 18098 473 17625
ARKNMI 18/11/2010 17625 385 17240
ARKNMI 17/1/2011 17240 959 16281
ARKNMI 17/2/2011 16281 510 15771
ARKNMI 25/3/2011 15771 163 15608
ARKNMI 28/3/2011 15608 1239 14369
ARKNMI 15/4/2011 14369 1926 12443
ARKNMI 26/6/2011 12443 932 11511
ARKNMI 4/8/2011 11511 457 11054
ARKNMI 10/8/2011 11054 721.35 10332.65
ARKNMI 15/09/2011 10332.65 103.05 10229.6
ARKNMI 26/10/2011 10229.6 824.4 9405.2
ARKNMI 15/11/2011 9405.2 9227.15 178.05
ARKNMI 20/11/2011 178.05 1563.27 -1385.22
ARKNMI 25/11/2011 -1385.22 571.93 -1957.15
ARKNMI 30/11/2011 -1957.15 1406.64 -3363.79

1 solution

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)

thatraja · Answer 1 · 2011-12-04T23:07:00

Solution 1

Check these(But I got these in Google)

30, 60, 90+ Days calculation[^]
Breaking aging balances out into columns[^]

Posted 4-Dec-11 23:07pm

thatraja

Comments

Amir Mahfoozi 5-Dec-11 6:59am

+5'ed :)