Skip to Content
author's profile photo Former Member
Former Member

Need to display 2 dates in one column in Report

Hi All,

I have two date chars, 'Begin date' (4/1/2007 ) & 'End date' (10/1/2011 ) in two different coulums & I need to display them in one column like 4/1/2007 - 10/1/2011, which would specify period i.e 'Begin date' to 'End date'. Can anyone please let me know how I could do this in Query designer?

Thanks!!

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 07, 2008 at 04:33 PM

    Hi,

    do you want to display this in all records or just the header of your column?

    In all records would be complicated

    In the header of a column just populate text variable via an ABAP exit....

    hope this helps...

    Olivier.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      well... what from where are those dates coming? are they user input? comming from the the infoprovider and or some attributes??

      Perhaps you can implement a virtual char and populate it via an ABAP exit...

      hope this helps...

      Olivier.

  • Posted on Jan 07, 2008 at 04:44 PM

    Create a Customer Exit variable. You can combine the two values using the CONCATENATION option

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 07, 2008 at 04:46 PM

    as per ur issue it seems u want tod isplay the date start and end in the header area

    this can be acheived using Text variables.

    u can create 2 text variables whose value is either user entry and whose reference char is Calday

    lets say ur user enters 2 date ,one as start date and another as end date.

    so u can create a variable A & B whose reference characteristics is 0calday

    now in query designer u select in column description where u wish to display date.

    then in description side u will see a icon

    if u click it u will be able to include text variabel in description

    now here create 2 variables x & y

    variable x

    replacement path variable

    reference char---0calday

    replacement path tab....

    variable is replaced by variable

    now select ur variable A.

    similarly create variable y

    theni n description u can include variable and put like this...

    variablex----variable y

    this should solve ur issue

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.