This discussion is archived
2 Replies Latest reply: Feb 4, 2013 7:16 PM by 938670 RSS

very urgent

938670 Newbie
Currently Being Moderated
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 Journeyer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    THX A LOT

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points