Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Condition in MQL query with Report Designer

  1. #1
    Join Date
    Apr 2010
    Posts
    149

    Default Condition in MQL query with Report Designer

    Hi,
    in my metadata I have a date field (i.e. PurchaseDate).
    How I can define this condition:
    WHERE year of PurchaseDate > current year?
    Which is the syntax to obtain the "current year"?
    Thanks!

  2. #2
    Join Date
    Mar 2003
    Posts
    8,085

    Default

    Get the latest news and tips and tricks for Pentaho Reporting at the Pentaho Reporting Blog.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.