Date From Database As Well As Prompt

Legacy Poster

• August 15, 2014 14:31

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.

 

 

0

• 

  Legacy Poster

  ★ BarTender Hero ★

  • August 18, 2014 12:42

  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
• 

  Legacy Poster

  ★ BarTender Hero ★

  • August 18, 2014 14:19

  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.

  0

Please sign in to leave a comment.