Show the values of yesterday

[#1]

Dear all,

I would like to create a textbox that shows the value of today and yesterday. So therefore I have created the following two variables:

SET vToday = Today();

SET vYesterday = vToday- 1;

However, when I create a text box now in which I would like to show the value of vYesterday I get a " -"  value. Any thoughts on how I can perform operations ( + / - days) on a date variable?

[Frank_Hartmann · Accepted solution]

see  attached sample

SET vToday ='Today()';

LET vYesterday = '=$' & '(vToday)' & '-1';

in textbox use:

date(vYesterday)

hope this helps

[avinashelite]

may be like this

SET vToday = Today();

SET vYesterday = Today()- 1;

[antoniotiman]

Let vToday = Today();

Let vYestarday = Date(vToday -1);

[#5]

please try this

Let Vtoday=Today();

Let Vyesterday= Today()-1;

textbox:

=Date($(Vyesterday))