This discussion is archived
3 Replies Latest reply: May 15, 2012 11:24 PM by 788462 RSS

MONTHNAME(date)

808195 Newbie
Currently Being Moderated
hi all,

I have a report, in that one column is MONTHNAME(date), return data like Jan,Feb,Mar.... . If I apply a filter on this column like MONTHNAME(date) = 'Apr', No results message will come. If I apply filter like MONTH(date) = 4, results will come.

Please give your suggestions on this as soon as possible.

Thanks and Regards,
Jagadish

Legend

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