topic Re: Validation on date field in Application Development and Automation Discussions

Validation on date field

PAL14 — Fri, 08 Aug 2008 08:11:06 GMT

I need to validate a date field

for eg:

SELECT-OPTIONS : dat FOR ekko-aedat.

When user enter month less than 1 or greater than 12 an

error message must be shown.

Please help me with this

Thanks

Pradeep Alex

Re: Validation on date field

bpawanchand — Fri, 08 Aug 2008 08:13:49 GMT

use AT SELECTION-SCREEN event to validate the fields on the selection-screen.

Regards

Pavan

Re: Validation on date field

former_member541575 — Fri, 08 Aug 2008 08:15:50 GMT

AT SELECTION-SCREEN ON S_DATE.

SELECT date FROM vbrk

WHERE DATE IN S_DATE and (month >=1 || month <=12).

IF sy-subrc NE 0.

MESSAGE i000(z_msg).

ENDIF.

Re: Validation on date field

JozsefSzikszai — Fri, 08 Aug 2008 08:17:06 GMT

hi Pradeep Alex,

welcome to SDN

you are on the right track already! you created the select option refering to a standard date field. it means, the check will happen automatically, no need for more coding! Just give it a try!

hoep this helps

Re: Validation on date field

Former Member — Fri, 08 Aug 2008 08:17:17 GMT

Pradeep,

AT SELECTION-SCREEN ON dat.

check here.

message.

When user enter month less than 1 or greater than 12 an

error message must be shown.

Please help me with this

am not sure from which date you want to compare month?as i believe there should be always two date for any kind of comparision.

is it with sy-datum?

Amit.

Re: Validation on date field

Former Member — Fri, 08 Aug 2008 08:19:28 GMT

Hi Pradeep,

There is no need to validate the date field. as it refers to the standard date format field, the date validation is performed automatically.

Regards,

Chandra Sekhar

Re: Validation on date field

Former Member — Fri, 08 Aug 2008 08:21:45 GMT

Hi pradeep,

your field ekko-aedat has datatype DATS, i.e. dictionary standard type for date.

You do not need to give any validation.

Regards,

Anirban

Re: Validation on date field

Former Member — Fri, 08 Aug 2008 08:57:06 GMT

HI,

ekko-aedat is of type dats.

so system will automatically take care of your requirement.

No need of using at selection-screen and all theese things..

Re: Validation on date field

Former Member — Fri, 08 Aug 2008 09:01:12 GMT

SELECT-OPTIONS : dat FOR ekko-aedat.

AT SELECTION-SCREEN.

loop at dat.

if dat-low4(2) <1 and dat-low4(2) >12.

MESSAGE e000(ZRAM) with 'Enter Correct Date'.

endif.

endloop.

here ZRAM is message class you can here ur own class name.

rgds

rajesh

Re: Validation on date field

Former Member — Fri, 08 Aug 2008 09:24:47 GMT

Hi Pradeep,

As I understand your question is " How to validate and give error if the date range entered is for more than12 months or less than 1 month?"

As many of the repliers have suggested you can validate it in

At SELECTION-SCREEN ON dat. "dat is your select-option

Use FM HR_HK_DIFF_BT_2_DATES to get months between dat-low and dat-high.

If the months come out to be less than 1 or greater than 12 give appropriate error message.

Hope this solves your problem.

Thanks,

Hitesh

Re: Validation on date field

PAL14 — Fri, 08 Aug 2008 09:35:45 GMT

Is that possible to use offset for this validation,If so how it can be done.

Re: Validation on date field

SuhaSaha — Fri, 08 Aug 2008 09:41:31 GMT

Hello,

Try this,


AT SELECTION-SCREEN ON S_DAT.
IF S_DAT-LOW+4(2) < 1 OR S_DAT-LOW+4(2) > 12.
  <ERROR MESSAGE>.
ENDIF.

I beleive this is irrelevant as SAP will automatically perform this check & throw an error message.

BR,

Suhas

Edited by: Suhas Saha on Aug 8, 2008 11:42 AM

Re: Validation on date field

PAL14 — Fri, 08 Aug 2008 09:52:10 GMT

Thanks every body for helping me