topic Re: Enter a valid value in Application Development and Automation Discussions

Enter a valid value

Former Member — Thu, 27 Mar 2008 13:06:54 GMT

Hi!

I get the message "Enter a valid date ".

Whats wrong ?

Can u please help. Or do you know another FM

for such purposes ?

I must be able to populate various date formats

e.g 04/24/2007, 04-24-2007 .....

Regards

sas

data s type sy-datum.
*04/24/2007

CALL FUNCTION 'CONVERT_DATE_TO_INTERNAL'
  EXPORTING
    date_external                  = '04/24/2007'
 IMPORTING
    DATE_INTERNAL                  = s
          .
write s.

Re: Enter a valid value

Former Member — Thu, 27 Mar 2008 13:10:33 GMT

you need to external, not to internal.

internal date format is yyyymmdd (8 characters).

Re: Enter a valid value

Former Member — Thu, 27 Mar 2008 13:13:09 GMT

Hi,

Give the dates without the slash .

Remove '/'

Reward if helpful.

Regards.

Re: Enter a valid value

Former Member — Thu, 27 Mar 2008 13:15:18 GMT

USE THE FOLLOWING CODE

DATA: W_DATE TYPE CHAR10.

CALL FUNCTION 'CONVERT_DATE_TO_EXTERNAL'

EXPORTING

DATE_INTERNAL = SY-DATUM

IMPORTING

DATE_EXTERNAL = W_DATE

EXCEPTIONS

DATE_INTERNAL_IS_INVALID = 1

OTHERS = 2

WRITE: W_DATE.

Re: Enter a valid value

dhruv_shah3 — Thu, 27 Mar 2008 13:22:00 GMT

Hi,

Write date in YYYY-MM-DD format

Regards,

Dhruv Shah

Re: Enter a valid value

Former Member — Thu, 27 Mar 2008 13:24:21 GMT

Hi,

data : date(10) type c value '31'.01.2008'm,
                   s type sy-datum.
 
CALL FUNCTION 'CONVERT_DATE_TO_INTERNAL'
  EXPORTING
    date_external                  = date
 IMPORTING
    DATE_INTERNAL                  = s
          .

Regards,

Morris Bond.

Reward Points if helpful.

Edited by: Morris Bond on Mar 27, 2008 2:24 PM

Re: Enter a valid value

Former Member — Thu, 27 Mar 2008 13:31:35 GMT

Dear All this is not what Im asking

I need a solution whereby I can

input exactly either

04/24/2007 or 04-24-2007 or 24/04/2007

and getting

as output -> YYYYMMDD

Regards

sas

Re: Enter a valid value

Former Member — Thu, 27 Mar 2008 14:04:05 GMT

Hi Erdam,

Go through this simple code, i have not used any function module for date conversion.

PARAMETERS:

p_date(10) TYPE c.

DATA w_date(8) TYPE c.

w_date0(4) = p_date6(4).

IF p_date0(2) > 12 OR p_date3(2) LE 12.

w_date4(2) = p_date3(2).

w_date6(2) = p_date0(2).

ELSEIF p_date0(2) LE 12 OR p_date3(2) > 12.

w_date4(2) = p_date0(2).

w_date6(2) = p_date3(2).

ENDIF.

WRITE w_date.

best regards

Anup.