Variable not working.

[#1]

hi,

i have created two variable for startdate=min({$}Date) and enddate=max({$}Date). but every time i open qvw both the variable changes into number format like '54621' likewise. please help.

[mdmukramali]

Dear Piyush,

Try to create startdate=min(Date) and

                    enddate=max(Date).         

check whether the   Date is in number format or in date.

if it is in number format then

               startdate=Date(min(Date))

                         enddate=Date(max(Date))

Thanks,

Mukram.

[fdelacal]

you should put the format.

date(yourfield,'YYYY/MM/DD')

startdate=date(MIN(yourfield),'YYYY/MM/DD')

                         enddate=date(MAX(yourfield),'YYYY/MM/DD')

HOPE THAT HELPS

[#4]

you need to set date format..

Go to Settings ---> Document Properties --> Number --> Select "Variables" on drop down.

Then you can set format for your variable..

Karthik

[saumyashah90]

Hi Piyush what you try is

startdate=Date(min({$}Date),'DD-MM-YYYY')

enddate=Date(max({$}Date),'DD-MM-YYYY')