Transform A Date In Day Of The Year Help S’abonner

0
Avatar
Legacy Poster

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,

5 commentaires

0
Avatar
Michael Toupin (mtoupin
Actions pour les commentaires Permalien

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.

1
Avatar
Legacy Poster
Actions pour les commentaires Permalien

[attachment=1381:Julian Date.JPG]

0
Avatar
Legacy Poster
Actions pour les commentaires Permalien

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
Avatar
Legacy Poster
Actions pour les commentaires Permalien

It works the same. Did you try it?
[attachment=1384:juliandate.JPG]

0
Avatar
Legacy Poster
Actions pour les commentaires Permalien

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.

Vous devez vous connecter pour laisser un commentaire.