Current Date Plus Experation Date Via Database Follow
Hi and thanks for taking a moment to help me. I am new to Bar Tender and have no problum adding the date with the offset by x number of days. But my issue is i pull my data from an Access data base and i have a field named exp date that is the number of days until experation for that item. each item has its own experation date i.e. 180 or 35, 27. So what i am tryiing to do is figure out how to have a date that is todays date + the experation number of days 3/1/2012 + 180. I have tried in the VB script choosing single line expression = field("the field name") + Date. i am getting 12386647 not 8/28/12 . is there a way to make this work?
Hope i made sense!!!
Please sign in to leave a comment.