Expiry date from manufacturing date

Issues related to label design (working with databases, data processing, RFID encoding etc.) and printing (from NiceLabel Express, NiceLabel Pro, NiceForm and NicePrint)

Moderators: Georges, milos, NiceLabel Support Team

Post Reply
ascelpius
Newcomer
Posts: 4
Joined: Wed Jul 08, 2020 9:07 am

Expiry date from manufacturing date

Post by ascelpius » Wed Jul 08, 2020 10:05 am

Hi all!

I am trying to automate expiry date calculation from manufacture date in yyyy-MM-dd. The problem I'm having is that the expiry date always has to be the last day of the month. So if my manufacturing date is 2020-03-18 and it expires after 2 years then the expiry date should be 2022-03-31.
Do you guys have any recommendation how to approach this, as a simple date offset will not work in this case (or at least I think :roll: )

User avatar
Saso
NiceLabel
NiceLabel
Posts: 2984
Joined: Mon Sep 04, 2006 8:09 am
Contact:

Re: Expiry date from manufacturing date

Post by Saso » Wed Jul 08, 2020 10:12 am

Hi ascelpius,

NiceLabel doesn't have such feature built-in, but it is fairly easy to add it with a VBScript/Python code.
We have discussed this already, see this post with a code example.
Saso Fleiser
Senior Technical Product Specialist

ascelpius
Newcomer
Posts: 4
Joined: Wed Jul 08, 2020 9:07 am

Re: Expiry date from manufacturing date

Post by ascelpius » Wed Jul 08, 2020 11:00 am

Thank you, this helped a lot :D

Post Reply