Possible to assign a dummy date on Today()?

[Anonymous]

Hi Expert,

Would like to check if possible to assign a dummy date on today()?

Appreciate it in advance?

-Joycelyn

[Chanty4u]

hi toh,

hope this thread will help somewat.

dummy date values in graph

Suresh

[Anonymous]

Thanks for the thread sharing, It is very useful knowledge.

However, my concern is remain open:

i would like to force the today() to first day of the month. It is purely for monthend checking purposes.

[sunny_talwar]

Not sure what you are trying to do. Would you be able to share an example with your expected output?

[swuehl]

I don't think you can trick QV easily to not use the system date (which you could change if you have the appropriate rights) and use a user selectable date instead.

What you can do is using a variable vToday in all instances where you are currently using Today() function.

Then set the variable to

=Today()

except when you are testing special dates (Monthend, Monthstart, leap year's day etc).

=Makedate(2015,12,1)