HANA - input parameter for keydate

[j_vandersterren]

Hi,

Can somebody help us with the following issue.

In HANA studio we created a view based on a time dependent table.

In the view we created a input parameter P_keydate (NVARCHAR - 😎

In the calculated colum we created a field named Keydate (NVARCHAR - 😎 with expression: '$$P_KeyDate$$'

And in the filter expression we derived the keydate:

("BEGDA" <='$$P_KeyDate$$' and "ENDDA" >='$$P_KeyDate$$' )

When we look at the data preview and enter a value for the input parameter (for example: 20150710) data is shown. Note: if we use an other format no data is shown.

We have the following questions:

• How can we default enter the current date in the parameter?
• How can we use the open Value help dialog and select a date?

Regards,

Jos

[j_vandersterren · Accepted solution]

Solved it myself:

Change keydate to calculated column (type date) fill this with now()