topic Re: Help on date format in Application Development and Automation Discussions

Help on date format

Former Member — Fri, 01 Feb 2008 09:05:48 GMT

Hi Everyone,

I am reading date from a file which is in the form YYYYMMDD.

Is there any functional module that checks the user's date format and changes the format according to it.

for eg. if the user has a setting DD.MM.YYYY then YYYYMMDD should be converted to this format.

Helpful answeres will be certainly rewarded.

Thanks,

Sandeep

Re: Help on date format

former_member188829 — Fri, 01 Feb 2008 09:08:02 GMT

Hi,

Check this Example..

DATA:V_DATE(10).

concatenate sy-datum6(2)'.' sy-datum4(2)'.' sy-datum+0(4) into v_date.

Write:V_DATE.

Or Use the FM:

CONVERT_DATE_TO_INTERNAL

Re: Help on date format

Former Member — Fri, 01 Feb 2008 09:10:06 GMT

CONCATENATE p_date+6(2) '/'

p_date+4(2) '/'

p_date+0(4) INTO p_date1 .

regards

kk.

Re: Help on date format

Former Member — Fri, 01 Feb 2008 09:12:51 GMT

Hi,

Use the function module CONVERT_DATE_TO_INTERNAL..

CALL FUNCTION 'CONVERT_DATE_TO_INTERNAL'

EXPORTING

DATE_EXTERNAL = V_DATE_EX

IMPORTING

DATE_INTERNAL = V_DATE.

Regards,

Satish

Re: Help on date format

Former Member — Fri, 01 Feb 2008 09:14:05 GMT

hi sandeep

plz go to debugging

in that give sy-datum field in fields of the debugger

then u will be knowing the format of the date

then u can use the correct concatenation formula inorder to fit the format of the date in the sap.

if satisfied plz reward

regards

samarendra

Re: Help on date format

Former Member — Fri, 01 Feb 2008 09:19:41 GMT

I dont think you need any FM in this case. Anyway SAP is going to store date in YYYYMMDD format internally.

So you can assign date value from file which is in YYYYMMDD with out any validations.

then after depending upon user setting date is going to dispaly. You need not do anything.

Re: Help on date format

Former Member — Fri, 01 Feb 2008 09:20:06 GMT

Hi sandeep

There is a table USR01 where data format for current user is stored.

pass user name to 'BNAME' field

'DATFM' field value gives you the type of date format set.

then you can dynamically write code according to the date format set.

eg.

CASE DATFM

when '2'

concatenate sy-datum6(2)'.' sy-datum4(2)'.' sy-datum+0(4) into v_date.

when '

endcase.

I think this will solve your problem'

Please reward points if this solves ur problem

Sukhi.

Re: Help on date format

Former Member — Fri, 01 Feb 2008 09:20:12 GMT

Use function module '/SAPDII/SPP05_CONVERT_DATE'.

Reward if found useful

Re: Help on date format

Former Member — Fri, 01 Feb 2008 16:38:11 GMT

have you used SET COUNTRY.

i think it will work. try it.