date and time in correct format ??

[Former Member]

hi,

I have a date field FD1 in one of my custom table say X.

I created a dialog screen in which i inserted that field from the dictionary, and when it was displayed the value was displayed as 20080807 and not as 08/07/2008.

why so ??

so in the screen field attribute, i unchecked "from dict" and changed the format to DATS.

so now the value was displayed as 08/07/2008.

But then now when i insert this in another custom table , this value is stored as 20080807.

how to deal with this ?? i need the value to be as 08/07/2008 everywhere !! any suggestions.

thks

[Former Member]

hi,

I have a date field FD1 in one of my custom table say X.

I created a dialog screen in which i inserted that field from the dictionary, and when it was displayed the value was displayed as 20080807 and not as 08/07/2008.

why so ??

so in the screen field attribute, i unchecked "from dict" and changed the format to DATS.

so now the value was displayed as 08/07/2008.

But then now when i insert this in another custom table , this value is stored as 20080807.

how to deal with this ?? i need the value to be as 08/07/2008 everywhere !! any suggestions.

thks

[valter_oliveira]

Hello.

A DATE field will always be stored internaly as AAAAMMDD format inside internal or database tables. However, when you display it, it appears with user definitions format, like DD/MM/YYYY, or MM/DD/YYYY, and so on ...

Regards.

Valter Oliveira.

[Former Member]

Hi,

use the FM "CONVERSION_EXIT_IDATE_OUTPUT"

Regards,

Syf

[Former Member]

Hi ,

This is because DATS type is always stored in SAP as YYYYMMDD and displayed to user as per user setting.

you can check this setting in System -> User Profile -> Own data -> Defaults -> Date Format.

Regards,

Mohaiyuddin