Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
see attached sample
SET vToday ='Today()';
LET vYesterday = '=$' & '(vToday)' & '-1';
in textbox use:
date(vYesterday)
hope this helps
see attached sample
SET vToday ='Today()';
LET vYesterday = '=$' & '(vToday)' & '-1';
in textbox use:
date(vYesterday)
hope this helps
may be like this
SET vToday = Today();
SET vYesterday = Today()- 1;
Let vToday = Today();
Let vYestarday = Date(vToday -1);
please try this
Let Vtoday=Today();
Let Vyesterday= Today()-1;
textbox:
=Date($(Vyesterday))