date and month conversion from given date.

[deepak_t2]

Hi Experts,

In my requirement, in select-options i need to give month and year only. ( no need date).

and it will get corresponding details for the month.

Kindly give me the any examples.

Thanks in advance.

Moderator message: date formatting questions = FAQ, please search before posting.

locked by: Thomas Zloch on Aug 31, 2010 5:10 PM

[Sandeep_Kumar]

so what is the problem ?

use data type char and declare select-option with length 6.

[deepak_t2]

Hi,

I fetch date from VBRK table , so i need to convert.

Ex: 08.2010 like this i need to give in select options.

Regards

[Former Member]

Hello,

This is a FAQ. You will have to just concatenate the range starting from the date 01 till the end of the month just before where ever you are using this particular select-option in the where condition of the select.

This falls under a basic date question. So please search in SCN before posting.

Vikranth