topic date and time in correct format ?? in Application Development and Automation Discussions

date and time in correct format ??

Former Member — Thu, 07 Aug 2008 19:04:34 GMT

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

Re: date and time in correct format ??

valter_oliveira — Thu, 07 Aug 2008 19:12:28 GMT

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.

Re: date and time in correct format ??

Former Member — Fri, 08 Aug 2008 06:52:13 GMT

Hi,

use the FM "CONVERSION_EXIT_IDATE_OUTPUT"

Regards,

Syf

Re: date and time in correct format ??

Former Member — Fri, 08 Aug 2008 06:56:36 GMT

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