‎2008 Apr 25 11:24 AM
Hi...All....
Iam having a date field in selction screen.....
now if i click f4 and enter one date it is inserting dd/mm/yyyy format
now my requirement is to change that format as mm/dd/yyyy with help of coing in the report only!!!!
Thank you,
Naveen Inuganti.
‎2008 Apr 25 11:28 AM
TO CONVERT DATE FORMAT dd/mm/yyyy format
to format as mm/dd/yyyy
date = p_date
mnths = p_date+6(2).
days = p_date+4(2).
yrs = p_date+(4).
concatenate mnths days yrs into date.
this will help
anya
‎2008 Apr 25 11:27 AM
‎2008 Apr 25 11:28 AM
TO CONVERT DATE FORMAT dd/mm/yyyy format
to format as mm/dd/yyyy
date = p_date
mnths = p_date+6(2).
days = p_date+4(2).
yrs = p_date+(4).
concatenate mnths days yrs into date.
this will help
anya
‎2008 Apr 25 11:29 AM
Hi,
You can change it in users profile on menu bar according to your requirement.
Thanks,
Sarada
‎2008 Apr 25 11:33 AM
Hi,
Use offset functionality and concatenate
date1 = 25/04/2008
concatenate date13(2) '/' date10(2) date1+5(4) into date2.
Reward,if useful.
Thanks,
Chandu
‎2008 Apr 25 11:41 AM
Hi Naveen,
try function module 'DATUMSAUFBEREITUNG' it converts dates to any date format you want.
Thanks®ds,
Sree.