Can anyone help me to resolve this issue?
I want to reduce 1 month from anydate given and should give me the new date. This should be done thorugh the transformer.
Can anyone tell me a function and its usage?
Subtract 1 month from any date given
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 238
- Joined: Fri Jul 25, 2008 8:55 am
There are various ways to do this using different functions. The answer depends on how you define "subtract one month". What is one month less than "July 31"? The simple method is to use ICONV() and OCONV() to convert a display date into an internal date, then subtract 30 and reconvert to a display date. But this might not satisfy your rules and a more complex method would need to be used.
Last edited by ArndW on Wed Jul 30, 2008 7:17 am, edited 1 time in total.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 238
- Joined: Fri Jul 25, 2008 8:55 am
-
- Premium Member
- Posts: 238
- Joined: Fri Jul 25, 2008 8:55 am
Fixed what, Craig (I love revisionist history)
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>