Classic file types are no longer available for use as of January 2021. You can transition your classic files or download a PDF. Learn More

dynamic value as parameter

Comments

3 comments

  • Regan

    Hi Ganesh! 

    Let's first try not using a parameter. Let's go ahead and use a filter in the WHERE clause: field_name to filter = current_date. Make sure the field name is a fate datatype. 

    Please let me know if you are still having trouble!

    0
  • Ganesh Karri

    Hi Regan,

    My query is working if I use current date directly in the where condition. The user wants the latest report by default but also want the flexibility to pass a certain date and get report up to that date.

    0
  • Regan

    Ganesh, I spoke with our experts in Wdata and it sounds like as of right now there isn't a way to use a function such as CURRENT_DATE in a calendar-driven parameter. 

    If you would like help with a workaround or another possible solution I would recommend contacting support! I have included their contact information below:

    Phone: 800-706-6526
    Email: Support@workiva.com

    0

Please sign in to leave a comment.