Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

date format

naveen_inuganti2
Active Contributor
0 Likes
584

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.

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
564
  • 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

5 REPLIES 5
Read only

Former Member
0 Likes
564

you kan use EDIT MASK for this

Read only

Former Member
0 Likes
565
  • 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

Read only

Former Member
0 Likes
564

Hi,

You can change it in users profile on menu bar according to your requirement.

Thanks,

Sarada

Read only

Former Member
0 Likes
564

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

Read only

Former Member
0 Likes
564

Hi Naveen,

try function module 'DATUMSAUFBEREITUNG' it converts dates to any date format you want.

Thanks&regds,

Sree.