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
588

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
568
  • 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
568

you kan use EDIT MASK for this

Read only

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

Hi,

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

Thanks,

Sarada

Read only

Former Member
0 Likes
568

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
568

Hi Naveen,

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

Thanks&regds,

Sree.