Variable getting change???

[Anonymous]

Hi Experts,

This post quite been simple but getting trouble with this...

I have declared a variable in Document properties, like "=date(today())"

After some days or subsequent reload the value is getting changed to some date, I wanted the value to be constant as "=date(today())".

How could I resolve this???

Many thanks in Advance...

[Anonymous]

Ya thanks yaar...

I am using that variable as calender object so whenever i change date in calender object automatically my variable =today() is changing to the some "10/09/2012" date...

If i open for 10-Oct-2012 that "=today()" changing to to "10/09/2012" date subsequently if i open for 11-Oct-2012 it should change the today() date 11th OCT right?? but it is not changing

[sivarajs]

Today will take the system date

Whats your variable exactly want to do for you?

[Anonymous]

daily when i open the application the date should change to current date i.e.today..(as mentioned in the screenshot) but it not automatically changing to current date that is the exact problem.. I wanted the date to be 29th OCT but stil in 5th OCT...

Since my variable is getting change it is adopt to that particular date(5th OCT) not as today()...

[sivarajs]

I dont know how you are calling date field into calendar object but for me its coming

vToday=today()

[magavi_framsteg]

Also, it makes a big difference if you declare your variable vToday with LET or SET.

If you declare it in your load script, you should use SET.

SET vToday = today();

Kind regards

Magnus Åvitsland

BI Architect Consultant

Framsteg Business Intelligence Corp.