Calculated date field in report writer

(0) Share

Report

Posted on by VidyaG

Hello,

I need to add calculated field in report write that displays a Date Range.

The base field is PA Period End Date and I need to calculate a new date which is 6 days prior. Then, combine these 2 fields to get the date range to print on the report.

Something like this if we do in SQL, (DateAdd("d", -6, PAPeriodEndDate)) + "-" + (PAPeriodEndDate).

How can we do this in report writer? Any suggestions? Much appreciated.

Thanks,

Vidya

Categories:

Microsoft Dynamics GP

All responses (4)

Answers (2)

VidyaG 15 on at

Like (0)

Report

RE: Calculated date field in report writer

Thank you.

I never thought it is as simple as that :). I am able to accomplish what I need.

-Vidya
Verified answer

David Musgrave MVP ... 14,036 Most Valuable Professional on at

Like (0)

Report

RE: Calculated date field in report writer

I don't think a function is required. Just subtract an integer value from a date.

Regards

David
VidyaG 15 on at

Like (0)

Report

RE: Calculated date field in report writer

David,

Thanks for the response.

Would you mind providing more details on this? Which function I can use to subtract an integer from a date in a calculated field?

I cant find a function that can serve the purpose from SDK documentation. I may be missing something here. Please help.

Thanks,

Vidya
Verified answer

David Musgrave MVP ... 14,036 Most Valuable Professional on at

Like (1)

Report

RE: Calculated date field in report writer

Hi Vidya

You should just be able to add subtract an integer from a date in a calculated field to go back a number of days.

I added some functions to the Report Writer as system user defined functions.

RW_AddMonth() Add or substract a month

RW_MakeDate() Create a date from Month, Day, Year values

RW_SetDate() Adjust a date using Month, Day. Year values

RW_DateToString() Convert a date to a string in any format

RW_DiffDate() Get the number of days between two dates

RW_SysDate() Get the system date

Details for these functions are in the RW_Func.doc document in the SDK (see \Tools\SDK folder on the Dynamics GP DVD image)

Regards

David