2 Replies Latest reply: Feb 4, 2013 9:16 PM by 938670 RSS

    very urgent

    938670
      HI Every one can any one help me plz

      I have a requirement that i want the date like

      1/2/2013
      2/2/1013
      3/2/2013
      4/2/2013

      4/2/2013 must me current date


      if go for next month it has to then it will must display

      1/3/2013
      2/3/2013
      .
      .
      .
      current date


      every month in future it has to display

      Edited by: 935667 on Feb 4, 2013 8:35 AM
        • 1. Re: very urgent
          Voltaire
          We can get the data with the below statement.

          case when year("Time"."Fiscal Date") = year(CURRENT_DATE) and month("Time"."Fiscal Date") = month(CURRENT_DATE) then 'Current Period' else (cast(month("Time"."Fiscal Date") as varchar(2))||'/'||cast(day("Time"."Fiscal Date") as varchar(2))||'/'||cast(year("Time"."Fiscal Date") as varchar(4))) end

          as this data is converted in to varchar datatype the Current Period would always appear in the last record. If this has to be sorted by date then the report need to have an extra date column sort the column. In the view hide the Date column and expose the Varchar Column. This should help.

          Let me know if it helped.

          Regards,
          Jay
          • 2. Re: very urgent
            938670
            THX A LOT