How give @prompt default value = today()

[Former Member]

Hi,

TKS reply the question.

I have a @prompt filter like this:

@Prompt('07.PLS Input Date:','A','Detail_time\YYYYMMDD',mono,free)

It can work.

but how to modify the syntax that have default value = today() ?

The following syntax is incorrect :

@Prompt('07.PLS Input Date:','A','Detail_time\YYYYMMDD',mono,free,,currentdate())

TKS!

Jackson

[Former Member · Accepted solution]

Hi,

Try with this formula in which u have to select a oldest date as DATE (i.e 01-01-1900)

var_Date = case when @prompt('EnterCurrent date','D',,mono,free) = '1900-01-01' then DATE else @prompt('Enter shipping date','D',,mono,free) end

By the above formula in most cases true condition gets failed so the user entered date i.e current date will be taken.

Cheers,

Suresh Aluri.

[Former Member · Accepted solution]

Thanks your answer, I think I get the solution.

Jackson

[Former Member]

Hi.

You can try with:

http://www.dagira.com/2008/07/21/using-a-magic-date-value-in-prompts/

Good luck!

[Former Member]

you can-not give dynamic value as a default in the prompt defintion. The default nust always be static text.

You can have "Today" as the default text in the defintion and then handle Today at the query level using decode statement.

You can try the following definition for default value:

@Prompt('07.PLS Input Date:','A','Detail_time\YYYYMMDD',mono,free,,{'Today'},,)