Default Value in Text box Prompt

[Kalyan cognoise]

Hi All,

Is it possible get the default value from the database in Textbox prompt?

Suppose my client wants to select last month end date, if I am in the month of april the textbox prompt should show 31-Mar-2009 defaulted.

Pls suggest me on this?

[cschnu]

Hi All,

Is it possible get the default value from the database in Textbox prompt?

Suppose my client wants to select last month end date, if I am in the month of april the textbox prompt should show 31-Mar-2009 defaulted.

Pls suggest me on this?

You should be able to use the expression _last_of_month in the Business Date/Time Functions

Code Select Expand

_last_of_month([INVOICE].[ISSUE_DATE])