Date formate into Domin Function

N

Nur Muhammad

I want to calculate the Following calculation into report:
Total Applied Amt Total Disbursed Amt
Today Apr 13, 2008 1000000.00
1000000.00
Month To Today Apr-01-Apr 10, 2008 1200000.00 5000000.00
Year to Date Jan 01-Apr 10, 2008 5000000.00 4000000.00

Today’s Total Applied Amount is calculated by following way:
=DSum("[car_loan_amt] ","tbl_car_master","[car_entrydate] =date()")

Today’s Disbursed Amt is calculated by following way:
=DSum("[car_sanction_limit] ","tbl_car_master","[car_disburse_date] =date()")

Now, how can I calculate the Month to Today’s Total Loan Amount and Total
Disbursed Amount using Domain Function or else?
And, how can I calculate the Year To Today’s Total Loan Amount and Total
Disbursed Amount using Domain Function or else?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I compare yearly shipped side by side (column) per part nu 1
cumprinc, not sure how to use it, someone please show me steps ple 1
Summarise data by Month 7
Serious help needed for this project Can anyone help me with this 7
Forecasting with formulas HELP 1
Interest and Payment Calculations 6
Fiscal YTD Calculation Not Working Correctly 2
PPMT Function Repost 12

Top