Focal Point
Using &DATEM in Report Caster

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/3231096082

April 16, 2008, 11:50 AM
Rick Man
Using &DATEM in Report Caster
Can I use &DATEM and &DATEYY in Report Caster? The RC Manuals say: Use the &YYMD amper
variable instead of &DATE.

Does that hold for these 2 variables also? If so how else can I get the month and year using Dialogue Manager?

Thanks


Reporting Server 7.6.10
Dev. Studio 7.6.8
Windows NT
Excel, HTML, PDF
April 16, 2008, 12:21 PM
GinnyJakes
quote:
&DATEM and &DATEYY

Rick,

It depends on what you want to use them for. &YYMD is a string of numbers. &DATE has the slashes in it, more properly used for a heading.

You can use &YYMD and the EDIT function to strip the year and month into separate variables.

Or you can try using the &DATEM and &DATEYY variables and see what happens. Eeker


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
April 16, 2008, 02:53 PM
Rick Man
&DATEM and &DATEYY don't seem to cause Report Caster any problems.

Thanks


Reporting Server 7.6.10
Dev. Studio 7.6.8
Windows NT
Excel, HTML, PDF