Automatic expiry date generate based on creation date

ameer ameer

• October 06, 2022 03:29

Hi all,

I got create data sources named DC (for creation date) and EXDate for Expiry date. But for the expiry date, it need to be 2 years from the creation date. Example as below. Date format for both DC and EXDate should be YYYY/MM/dd.

 

So I got use below script below script (shared by someone in this community) to apply logic for the +2 years for the EXDate. Result for EXDate are indeed +2 years, but the format been change to dd/MM/YYYY.

So how to change back the EXDate format become YYYY/MM/dd ? At the EXDate data source (at data type tab), I already choose date, then custom it become YYYY/MM/dd, but still not change.

 

Please advise. Thank you

0

• 

  Peter Thane

  ★ BarTender Hero ★

  • October 06, 2022 08:48

  As you have already asked the same question in https://support.seagullscientific.com/hc/en-us/community/posts/360049172374-set-expiry-date-automatically-based-on-input-creation-date?page=1#community_comment_9342002483095, that includes all the VB coding you are referencing, then I will respond in that forum post when I get a chance.

  I believe I know what the solution is but need to rebuild my test label again first to make sure.  

  0

Please sign in to leave a comment.