How to reduce one year from current date
Moderators: chulett, rschirm, roy
How to reduce one year from current date
Hi,
How to reduce one year from the current date. I already tried with DateFromDaysSince. But this logic does not work. Can anyone have other approach for this? Please help me to resolve this issue
How to reduce one year from the current date. I already tried with DateFromDaysSince. But this logic does not work. Can anyone have other approach for this? Please help me to resolve this issue
prabakaran.v
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 39
- Joined: Sun Apr 15, 2007 11:30 pm
This transformationw will give you the desired result -
((YearFromDate(link.Column)-1) :'-': link.Column[6,2] :'-': link.Column[9,2])
Where link.Column is your date field coming as an input,So If you have link.Column =2009-03-12 Then the result will be 2008-03-12
((YearFromDate(link.Column)-1) :'-': link.Column[6,2] :'-': link.Column[9,2])
Where link.Column is your date field coming as an input,So If you have link.Column =2009-03-12 Then the result will be 2008-03-12
"Books are as useful to a stupid person as a mirror is useful to a Blind person."
-
- Participant
- Posts: 39
- Joined: Sun Apr 15, 2007 11:30 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
U (one of our posters) did not ask the question.shalini11 wrote:U can try this function;
YearFromDate(CurrentDate())-1
The second person personal pronoun in English is spelled "you", not "u".
Please strive for a professional standard of written English on DSXchange. Among other things it makes things easier for those of us whose first language is not English.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
U (one of our posters) did not ask the question.shalini11 wrote:U can try this function;
YearFromDate(CurrentDate())-1
The second person personal pronoun in English is spelled "you", not "u".
Please strive for a professional standard of written English on DSXchange. Among other things it makes things easier for those of us whose first language is not English.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.