topic Re: Comparing Dates in Application Development and Automation Discussions

Comparing Dates

Former Member — Wed, 12 Nov 2008 06:05:42 GMT

Hi folks,

I have to use a validation for date field, for one of my select queries.

I am using it as select ##### where BUDAT > 01012006.

Is this correct way...or is there any other way to do so..please help me.

Thanks,

Shyam.

Edited by: shyam prasad on Nov 12, 2008 7:06 AM

Former Member — Wed, 12 Nov 2008 06:07:16 GMT

U should compare like this,

select ##### where BUDAT > 20060101

Former Member — Wed, 12 Nov 2008 06:10:32 GMT

why don't you declare a constant (same datatype as the one u are using in select query) with value 01012006.

then write the select statement using this constant.

if u have any problem, give the table and field u want to perform select upon, someone of us can help u.

Regards,

SAPient

Mohamed_Mukhtar — Wed, 12 Nov 2008 06:14:42 GMT

hi ,

[Comparing Dates|]

Thanks & Regards

rthoodi — Wed, 12 Nov 2008 06:17:33 GMT

Hi,

Date format should have been match with your default parameters

and from which table you are getting this date, because for dates there is no master table, so you can validate like this.

if not P_BUDAT is initial.

if P_BUDAT GT '20060101'.

message.

else.

endif.

endif,

former_member467220 — Wed, 12 Nov 2008 06:18:49 GMT

Hi,

when u r comparing dates, give date in YYYYMMDD format.

So in your case, u can write select #### where BUDAT > '20060101'.

Regards,

Devendra

Former Member — Wed, 12 Nov 2008 06:21:30 GMT

select ##### where BUDAT > '20060101'.