change date to EOM in ETL process

Focal Point

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

February 12, 2007, 04:48 AM

FrankDutch

change date to EOM in ETL process

In reporting it is possible to change the date into the End-Of-Month date with the formula

DATEMOV(PORTDATUM, 'EOM');

I would like to do the same thing in an ETL process, but can not find how to do this.

Any help would be appreciated.

	*Frank*
	prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7

February 12, 2007, 10:02 AM

susannah

Frank, if you're using data migrator, maybe you could put this post in the IWAY forum section of focal point. Maybe you'ld get an answer faster. just a thought.

In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID

February 12, 2007, 01:20 PM

newtofocus

Frank,

Depends on where you want to use it. You can put it in the target transformations if you want to store the end of the month in a target.

If you want to move the end of month in your ETL than put this in the source. Hope this helps.

WF7.1.4 Prod/Test, MRE, self serve, DM

February 13, 2007, 07:30 AM

FrankDutch

quote:
Depends on where you want to use it. You can put it in the target transformations if you want to store the end of the month in a target.

If you want to move the end of month in your ETL than put this in the source. Hope this helps.

I know I should be able to do that, but the specil function DATEMOV is not in the list of function within ETL.

	*Frank*
	prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7

February 13, 2007, 11:22 AM

newtofocus

What version or you using?. I have 7.1.1 and I can find it under functions->Date-Standard in the transformation caluculator.

WF7.1.4 Prod/Test, MRE, self serve, DM