topic Re: How to find user's current date format ? in Application Development and Automation Discussions

How to find user's current date format ?

Former Member — Tue, 24 Apr 2007 11:12:23 GMT

Hi guys,

i need to display some variable as per the user's current date format.

But it is always following DD.MM.YYYY whereas my user format is MM/DD/YYYY.

i know how to see it in system -- > user profile --> own data....

But i need to write code to find the current date format ...

HELP ME

Re: How to find user's current date format ?

Former Member — Tue, 24 Apr 2007 11:14:23 GMT

hi,

date format is stored in USR01 table.

regards,

ananth

Re: How to find user's current date format ?

Former Member — Tue, 24 Apr 2007 11:14:47 GMT

Hi,

Try this:

data: l_date_string(10).

write l_date to l_date_string.

write l_date_string.

Re: How to find user's current date format ?

Former Member — Tue, 24 Apr 2007 11:14:51 GMT

Hi!

It is stored in USR01 table DATFM field (its a number, which means a specific format).

Regards

Tamá

Re: How to find user's current date format ?

Former Member — Tue, 24 Apr 2007 11:15:10 GMT

you can write a select on USR01 table

select DATFM from USR01 into V_DATFM where bname eq sy-uname.

Re: How to find user's current date format ?

Former Member — Tue, 24 Apr 2007 12:06:01 GMT

Any Function module to change the date to user's current date format ????

Re: How to find user's current date format ?

Former Member — Tue, 24 Apr 2007 12:07:50 GMT

try with this

CONVERT_DATE_TO_EXTERNAL

Re: How to find user's current date format ?

Former Member — Tue, 24 Apr 2007 12:47:18 GMT

How can i write date in DD.MM.YYYY to a variable ???

Re: How to find user's current date format ?

Former Member — Tue, 24 Apr 2007 12:48:36 GMT

data: v_date(10).

write sy-datum to v_date using edit mask '__.__.____'.

Re: How to find user's current date format ?

Former Member — Tue, 24 Apr 2007 12:49:53 GMT

What is edit mask? is it the option of write statement ?//

Re: How to find user's current date format ?

Former Member — Tue, 24 Apr 2007 12:53:31 GMT

No one suggested to use edit mask ...it is not present in write statement help also

Thanks alot Ravi...

Re: How to find user's current date format ?

Former Member — Tue, 24 Apr 2007 12:57:43 GMT

Hi GUru,

It is there in write statement help. Under formatting options i guess.

Regards,

Ravi