topic Re: form painter: data format in command line in Application Development and Automation Discussions

form painter: data format in command line

Former Member — Fri, 29 Jun 2012 11:40:58 GMT

Hi together,

I want to insert a command line like...

IF MHNK-LAUFD GE >>certain date<<.

What format do I have to use for >>certain date<<.

e.g.:

YYYYMMDD or

YYYY/MM/DD or

YYYY.MM.DD or ...

I´ve already checked out several formats; without success.

Thanks for any help

Re: form painter: data format in command line

RaymondGiuseppi — Fri, 29 Jun 2012 11:59:46 GMT

This is a date (DATS) field, so use a format compatible with internal format 'YYYYMMDD', e.g. '20120629', or define a constant CONSTANTS: c_date TYPE D VALUE '20120629'.

(You are using SmartForms ?)

Regards,

Raymond

Re: form painter: data format in command line

Former Member — Fri, 29 Jun 2012 14:17:13 GMT

If you are using smartform/sap script then you will need to use conversion exits for date for the comparison to work. The format will depend on your profile in transaction SU3.

CONVERT_DATE_TO_EXTERNAL

CONVERT_DATE_TO_INTERNAL

Regards,

Shravan

Re: form painter: data format in command line

venkateswaran_k — Sun, 01 Jul 2012 07:18:30 GMT

Try using following statements in the Script.

/: SET DATE MASK = 'DD.MMMM.YYYY'

/: SET COUNTRY 'USA'

Regards,

Venkat

Re: form painter: data format in command line

Former Member — Mon, 02 Jul 2012 08:53:46 GMT

Hi,

although I set data mask 'YYYYMMDD' and put '20120601' for the actual date it doesn´t work.

By the way....I´m using trx. se71.

best

Re: form painter: data format in command line

RaymondGiuseppi — Mon, 02 Jul 2012 09:10:19 GMT

You are using SAPscript, so your syntax was not

IF MHNK-LAUFD GE '20120629.

but rather

/:   IF &MHNK-LAUFD& GE '20120629'.

You should force date to use a "sortable" format like YYYYMMDD

/: SET DATE MASK 'YYYYMMDD'.
/: IF &MHNK-LAUFD& GE '20120629'.
...
/: SET DATE MASK ' '.

The last statement to put date format back to default (before printing a date)

If that don't work, try to force data format before calling the SAPscript.

(I never liked way that SAPscript use to pass numerical, date or time fields...)

Regards,

Raymond