Search found 2 matches
- Mon Nov 20, 2006 10:14 am
- Forum: General
- Topic: Getting the last date of month using the first date of month
- Replies: 4
- Views: 3357
- Mon Nov 20, 2006 9:51 am
- Forum: General
- Topic: Getting the last date of month using the first date of month
- Replies: 4
- Views: 3357
Getting the last date of month using the first date of month
Hi,
I have to get the last date of month using the first date of month.
eg:
If the date is 20050401(YYYYMMDD), I need the value 20050430.
Is there any function in datastage to do this or is there any other way?
Kindly help me.
I have to get the last date of month using the first date of month.
eg:
If the date is 20050401(YYYYMMDD), I need the value 20050430.
Is there any function in datastage to do this or is there any other way?
Kindly help me.