Processing Date

chitravallivenkat · Post by **chitravallivenkat** » Fri Aug 08, 2008 1:35 am

In one the text report which i am generating should includes only transactions with processing_date within the monthly reporting period. E.g. 20080601 to 20080630 for the month of June report.

This is one of the selection cretria to generate the report using sybase.

How shal i implement this and the Processing_date is the field from one of the table from sybase database.

Please suggest me on this..

ray.wurlod · Post by **ray.wurlod** » Fri Aug 08, 2008 1:37 am

Two job parameters, for example jpStartDate and jpEndDate.

The SELECT statement then has the restriction

Code: Select all

WHERE Processing_Date BETWEEN #jpStartDate# AND #jpEndDate#

chitravallivenkat · Post by **chitravallivenkat** » Fri Aug 08, 2008 3:55 am

Thank you so much it worked out,

Similarly i have other selection cretria in which the Processing_month field should have the value of Last 12 month, counting back from October 31.

How shal i implement this.

chitravallivenkat · Post by **chitravallivenkat** » Fri Aug 08, 2008 3:55 am

Thank you so much it worked out,

Similarly i have other selection cretria in which the Processing_month field should have the value of Last 12 month, counting back from October 31.

How shal i implement this.

chitravallivenkat · Post by **chitravallivenkat** » Fri Aug 08, 2008 3:55 am

Thank you so much it worked out,

Similarly i have other selection cretria in which the Processing_month field should have the value of Last 12 month, counting back from October 31.

How shal i implement this.

chitravallivenkat · Post by **chitravallivenkat** » Fri Aug 08, 2008 3:57 am

Thank you so much it worked out,

Similarly i have other selection cretria in which the Processing_month field should have the value of Last 12 month, counting back from October 31.

How shall i implement this.

dineshrk · Post by **dineshrk** » Sat Aug 09, 2008 5:35 am

chitravallivenkat wrote:Thank you so much it worked out,

Similarly i have other selection cretria in which the Processing_month field should have the value of Last 12 month, counting back from October 31.

How shall i implement this.

Use the Iconv function to get the internal value of today's date and subtract 365 from that value and use an Oconv function to get the value of that date and pass the values to the SQL query.

ray.wurlod · Post by **ray.wurlod** » Sat Aug 09, 2008 4:32 pm

chitravallivenkat wrote:Thank you so much it worked out,

Similarly i have other selection cretria in which the Processing_month field should have the value of Last 12 month, counting back from October 31.

How shall i implement this.

Start with a clearer specification. Are you looking for a "year to date" figure starting from October 31, or the number of days since October 31, or perhaps the date of the most recent October 31? Until this is clear, an accurate suggestion can not be offered.