topic Re: date and month conversion from given date. in Application Development and Automation Discussions

date and month conversion from given date.

deepak_t2 — Tue, 31 Aug 2010 14:13:14 GMT

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

Re: date and month conversion from given date.

Sandeep_Panghal — Tue, 31 Aug 2010 14:22:15 GMT

so what is the problem ?

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

Re: date and month conversion from given date.

deepak_t2 — Tue, 31 Aug 2010 14:28:30 GMT

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

Re: date and month conversion from given date.

Former Member — Tue, 31 Aug 2010 14:33:00 GMT

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