Jump to content
We've recently updated our Privacy Statement, available here ×

Lionia1979

Members
  • Posts

    2
  • Joined

  • Last visited

Lionia1979's Achievements

Newbie

Newbie (1/14)

  • One Month Later
  • One Year In
  • Week One Done
  • First Post Rare
  • Conversation Starter Rare

Recent Badges

0

Reputation

  1. Hi I have a jasper report fetching data with following query: SELECT datepart(ww, LOGDATE) AS weeks from mc_logs This works. The problem comes when I replace the 'ww' with a parameter like SELECT datepart($P{DATETYPE}, LOGDATE) AS weeks from mc_logs Has anyone tried this or have a workaround?
×
×
  • Create New...