topic Re: Date FM in Application Development and Automation Discussions

Date FM

Former Member — Tue, 04 Jul 2006 14:55:41 GMT

Hi,

I need the information based on date when I write the select statement like begda = '01.04.2006'. No data is displaying.

Please let me know how to get the information.

Thanks,

Pavan.

Re: Date FM

Former Member — Tue, 04 Jul 2006 14:57:23 GMT

Hi,

Check the format in which the date is stored.

If it is 20060401, then use select query

select * from

ztab

where begda = '20060401'.

Best regards,

Prashant

Re: Date FM

Former Member — Tue, 04 Jul 2006 14:57:26 GMT

Dates are stored in the database with format YYYYMMDD. Change the format of the variable you are evaluating in the where clause.

-Kiran

Re: Date FM

Former Member — Tue, 04 Jul 2006 14:58:02 GMT

Hello Pavan,

The begda is only 8 characters date fields.

SO in the select statement u should give the date in the sy-datum format ie)20060401.

Hope u got the answer.

Reward the point and close the thread.

Regards,

Vasanth

Re: Date FM

RichHeilman — Tue, 04 Jul 2006 14:59:16 GMT

This is because all dates in the system are stored as YYYYMMDD. You need to convert to this format when trying to SELECT from db. If your date field is defined as type sy-datum, then the conversion is done for you.

You can do it like this.

where  begda = '20060104'.

Regards,

Rich Heilman