on 12-01-2008 10:41 PM
Hi
my input comes as
month year.( oct 2008 or Nov 2008 etc )
The target field is a Date.
I have tried using Date trans but it doesnt accept strings.
so is there a way send the incoming field without changing target data to string?
Regards,
Venkat.
Hi Venkat,
If you get value Oct 2008, what will be the date field value is it (01-Oct-2008)?
regards
Unni
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I am assuming you can bring in month & year in 2 seperate variable to UDF named as below
String strMonth & String strYear
java.text.DateFormat df = new SimpleDateFormat("dd/MON/yyyy");
java.util.Date today = df.parse("01""/"strMonth"/"strYear);
Now you have the date object & you can convert the way you need. Please note I am initializing the object to start of the month always.
Regards
Unni
Hi,
This is possible using Date Trans function.
src-->TransformDate->tgt
Format of Source Date - MMM yyyyy
Format of Target Date - MMM/yyyy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.