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?
Quote from: Kalyan cognoise on 30 Apr 2009 08:49:26 AM
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
_last_of_month([INVOICE].[ISSUE_DATE])