Fantastic, that works!
Great, simple, elegant solution to an obvious bug.
(Fixed the syntax by removing extra "Re"):
Replace(ToText(Today + {WorkOrders.shelf_life},'M/d/yy'), " ", "")
I agree with kray4660, and this is what I have done.
You could also create a dummy table that would accept a given parameter and cross reference a number of copies on that table. When you join to that table, you could have the number of records repeat for your cross-reference, which would...
thread767-1352528
As in the post previously referenced, I noticed an extra space before the day when formatting using the following:
(ToText(Today + {WorkOrders.shelf_life},('M/d/yy')))
This gives me a result of "12/ 6/13" when I am expecting "12/6/13"
Has anyone found a resolution to this...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.