on 02-20-2008 12:25 PM
Hi Experts!!!
I need to get "31-jan-08" for this requirement i am using FM
CONVERSION_EXIT_SDATE_OUTPUT using this i am geting output as 31.jan.2008 ...
Could you please tell me how to display in given format ?? or atleast how to remove that dots.
Thanks ,
shaheen
hi,
after getting that date in one variable u need so do split.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi shaheen,
Use the offset to solve your probem.
See the below code. The particular offset has been done for
20080231(YYYYMMDD). I want to convert this into MM/DD/YY.
CONCATENATE p_caufvd-gstrs+4(2)'/'
p_caufvd-gstrs+6(2)'/'
p_caufvd-gstrs+2(2)
INTO v_ssdate.
I think this code will help you.
Reward points if useful.
Thanks,
karthik
Edited by: karthikeyan Thangavel on Feb 20, 2008 1:55 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
It displays based on the user setting change the setting and try it
regards
Shiva
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Shaheen,
Please move the result into character type variable.
use replace statement .
Other way split statement.
Thanks
Phani
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
9 | |
7 | |
6 | |
5 | |
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.