topic Re: date format in Application Development and Automation Discussions

date format

naveen_inuganti2 — Fri, 25 Apr 2008 10:24:05 GMT

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.

Former Member — Fri, 25 Apr 2008 10:27:58 GMT

you kan use EDIT MASK for this

Former Member — Fri, 25 Apr 2008 10:28:06 GMT

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

Former Member — Fri, 25 Apr 2008 10:29:24 GMT

Hi,

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

Thanks,

Sarada

Former Member — Fri, 25 Apr 2008 10:33:57 GMT

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

Former Member — Fri, 25 Apr 2008 10:41:43 GMT

Hi Naveen,

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

Thanks&regds,

Sree.