@adjust - date range!

[DoctorGonzo]

Hi guys,

I want a drop down field containing 5 dates - 2 days either side of today.

Anyone got any ideas? I know an @adjust will be necessary!

Cheers!
Gonzo

 

[pmonett]

You simply need to calculate the variables and string them together to make a multi-value list.

Something like this:

WkToday:=@today;
WkDate_m2:=@Adjust(WkToday;0;0;-2;0;0;0);
WkDate_m1:=@Adjust(WkToday;0;0;-1;0;0;0);
WkDate_p1:=@Adjust(WkToday;0;0;1;0;0;0);
WkDate_p2:=@Adjust(WkToday;0;0;2;0;0;0);
WkList:=WkDate_m2:WkDate_m1:WkToday:WkDate_p1:WkDate_p2;

Then use WkList as values for your drop-down list.

Hope this helps !

Pascal.