How to compare Costing Date and Accounting Date
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=8748
Printed Date: 03 May 2025 at 2:31am
Topic: How to compare Costing Date and Accounting Date
Posted By: angelyin1984
Subject: How to compare Costing Date and Accounting Date
Date Posted: 29 Dec 2009 at 1:31am
|
helo..hope somebody can help me in this problem....thanks in advance..... Table1: Company| Division| Year | Accounting Date| Item Number | CO No 999 | 101 | 2009| 02/Feb/2009 | FKAFF000 | 0011012704 999 | 101 | 2009| 03/Feb/2009 | FFAAZ010 | 0011012705 Data type for Accounting Date is Date Time. Table2: Company| Facility| Costing Date| Item Number | Value Component1 999 | 11 | 20081224 | FKAFF000 | 0.3938 999 | 11 | 20071201 | FFAAZ010 | 0.8393 999 | 11 | 20080601 | FKAFF000 | 0.4633 999 | 11 | 20070101 | FFAAZ010 | 0.8685 Data type for Costing Date is Number. My Report need look like this: Accounting Date | Item No | CO No |Value Cost |Costing Date 02/Feb/2009 | FKAFF000 | 0011012704| 0.3938 | 20081224 03/Feb/2009 | FFAAZ010 | 0011012705 | 0.8393 | 20071201 Based on the Accounting Date and choose the nearest costing date value to display. How to do for this. I have no idea to do this. Please help. Really need HELP! Thank you very much..... |
Replies:
Posted By: hilfy
Date Posted: 29 Dec 2009 at 11:13am
|
Please don't cross-post. I have already answered this question http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=8734 - here .
-Dell
------------- Proviti, Data & Analytics Practice http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics |
Posted By: angelyin1984
Date Posted: 30 Dec 2009 at 5:34pm
ok. sorry.
|