Date From Database As Well As Prompt Follow

0
Avatar
Legacy Poster

Hello,

 

I'm working on a label that needs a calculated date which is based on a database field as well as a prompt at print value.

 

For examle I want the user to enter in relation to today. So 0 = today, 1 = tomorrow etc and the I want this number adding to a database field to give a total offset.

 

So we are packing tomorrows order (1) and this product has a display until of 6 days I want to print a display until of 7 days greater than todays date.

 

I tried to use date picker but the problem with this is that as far as I can see you can only limit the final date with doesn't work

 

The main objective is to stop the user selcting dates in the date.

 

Any help is grafefully received.

 

 

2 comments

0
Avatar
Legacy Poster
Comment actions Permalink

I'm not sure if this is the best way to do what you're asking, but I've attached a .btw file that does this. It uses the "DateAdd()" vba function to add the value from the database to a prompted value. You should see when you open it.

0
Avatar
Legacy Poster
Comment actions Permalink

Thanks nRyder.

 

I agree, there may be a better way but its beyond me and this works so I can use range checking to avoid using negative numbers i.e. dates in the pass and dates to far forward.

 

Thanks very much.

Please sign in to leave a comment.