Transform A Date In Day Of The Year Help
Hi Guys,
we have a strange question.
on a label we need a production date it works now .
now customers dont want the date in that field but the day of the year it is.
is it possible for bartender when it gets the date to calculate wich day of the year is .
like when the input is 31/12/2015 it should transform to day 365
Kind regards,
David,
-
Is the label creating the date based off of the current date, or is it getting it as a manual or external entry?
if it's using a date field in BarTender, just change the date type to julian to achieve this. If it's coming from a data entry or database, you'll have to write a VB script to convert it.
0 -
[attachment=1381:Julian Date.JPG]
1 -
Hi Guys,
thanks for the reply,
its comming from a database.
so i also thougt i needed to use vb script.
problem is i dont know any vbscript.
Anyone has an example.
Thanks.
0 -
It works the same. Did you try it?
[attachment=1384:juliandate.JPG]0 -
I have a Julian day code (jjj) entered in from the Data Entry Form. How can I get that day to transform to MM/DD/YYYY (Production Date) for
another data field?Looks like I will have to use VBScript?
I will then have another data field (Expiration Date) offset from entered jjj code using a number from a database.
0 -
I have the same problem. I need the day number in a DateMatrixCode. e.g. 3.1.2024 = 3
0 -
If you configure the DataMatrix date object like this then that should sort it
If the date is also included in a text or other field in the label then I would suggest you make the Data Source type and Object Method field and link the DataMatrix substring to that object
0
Please sign in to leave a comment.
Comments
7 comments