topic Re: validating the date field in Application Development and Automation Discussions

validating the date field

Former Member — Tue, 24 Jul 2007 05:56:03 GMT

Hi Friends,

i am facing problem while validating the date field,

i want to restrict the user to maximum of one year of intervel of his given date.

Regards,

Saleem

Re: validating the date field

sharadendu_agrawal — Tue, 24 Jul 2007 05:59:39 GMT

use the fm to get the difference between the 2 dates in terms of number of days and check the value as 365.

reward if helpful

cheers

sharadendu

Re: validating the date field

Former Member — Tue, 24 Jul 2007 06:00:31 GMT

have a try with this fm

data st2_date type sy-datum.

CALL FUNCTION 'CALCULATE_DATE'

EXPORTING

days = '0'

months = '+12'

start_date = sy-datum

IMPORTING

result_date = st2_date.

if s_date-high > st2_date.

message 'Error' type 'E'.

endif.

if helpful, reward

Sathish. R

Re: validating the date field

Former Member — Tue, 24 Jul 2007 06:03:35 GMT

call function 'FIMA_DAYS_AND_MONTHS_AND_YEARS'

exporting

i_date_from = p_lv_start_date

I_KEY_DAY_FROM =

i_date_to = p_lv_date1

I_KEY_DAY_TO =
I_FLG_SEPARATE = ' '

importing

E_DAYS =

e_months = p_lv_month_diff

E_YEARS =

using this FM u can find the diff between dates.

Re: validating the date field

Former Member — Tue, 24 Jul 2007 06:04:42 GMT

Hi saleem,

Use FM FIMA_DAYS_AND_MONTHS_AND_YEARS .

THis will Give differnece between two dates.

IF the number of days Gretaer than 365 OR 366 then give a error message.,

I hope it will solve your problem.

Thanks,CSR.

PS:Reward if helpful.

Re: validating the date field

Former Member — Tue, 24 Jul 2007 06:06:56 GMT

use this FM

CALL FUNCTION 'HR_ECM_ADD_PERIOD_TO_DATE'

EXPORTING

ORIG_DATE = 'your date'

NUM_DAYS = 0

NUM_MONTHS = 0

NUM_YEARS = 1 " add one year to it. it will automatically add one year irrespective of leap year

SIGNUM = '+' for addition

MESSAGE_HANDLER = MESSAGE_HANDLER

IMPORTING

RESULT_DATE = your_result

now check the date for futher processing

<b>reward points plz</b>

Message was edited by:

Fazeel