Hi, I'm writing from Italy, let me apologize about my simple English.
I'm testing your Demo-NiceLabel to understand if is good about my need.
So I have to say that it is really a very "nice" software... congratulations.
I made a Excel file (2003 Version), where I can put the labels' data.
I have a problem with the DATE FORMAT.
In Excel I have "dd/mm/yyyy" format (I tried also different others format, the TEXT FORMAT also), but NiceLabel change the date in "MM/DD/YYYY" or a NUMBER or a absurd value.
I tried to modify the "Variable Property"; "Date Format"; "Date". But when I print I have a ERROR BOX [ID:1023] "... THIS VALUE IS IT NOT VALID FOR THIS FORMAT ...".
Can you help me, many thanks in advance.
Best regards
Massimo
Date format
Moderator: NiceLabel Support Team
Re: Date format
Hi Massimo,
Data foramat used in MS Excel are not transfered to NiceLabel. You must be aware the Excel data sheet is not a "real" database and you cannot expect that all settings made in Excel will be transfered to other applications. This feature is not supported in the ODBC driver.
I made a quick test with mm/dd/yyyy format in Excel. I got the same result
. Obviously the ODBC driver doesn't know how to transfer data. I suggest you to change the date format in Excel. If possible set it to General and enter just plain numbers, like 10122010 (today's date).
Then define data format in NiceLabel: Variable properites/Validation tab: define Date format and set Output format as you wish.
Data foramat used in MS Excel are not transfered to NiceLabel. You must be aware the Excel data sheet is not a "real" database and you cannot expect that all settings made in Excel will be transfered to other applications. This feature is not supported in the ODBC driver.
I made a quick test with mm/dd/yyyy format in Excel. I got the same result
. Obviously the ODBC driver doesn't know how to transfer data. I suggest you to change the date format in Excel. If possible set it to General and enter just plain numbers, like 10122010 (today's date).Then define data format in NiceLabel: Variable properites/Validation tab: define Date format and set Output format as you wish.
Regards,
Sasa
Pre-sales Specialist
Sasa
Pre-sales Specialist
Re: Date format
Hi Rsas,
Sorry for long time to reply, I resolved the date problem by Excel's functions.
I split up the date in three different cells, one "DD", one "MM" and one "YY" and then I used the function "concatena" (I don't know the English name, maybe "concatenate") to create in an other cell the date YYMMDD. Now I have got an other problem, but I will open a new thread on the forum.
Thank a lot and greetings
Massimo
Sorry for long time to reply, I resolved the date problem by Excel's functions.
I split up the date in three different cells, one "DD", one "MM" and one "YY" and then I used the function "concatena" (I don't know the English name, maybe "concatenate") to create in an other cell the date YYMMDD. Now I have got an other problem, but I will open a new thread on the forum.
Thank a lot and greetings
Massimo
Re: Date format
I struggled with the same problem, however I didn't want to touch Excel since the data get's imprted that way from an ERP system.
The problem seems to be that if you format the variable as date and try to use Input MM/DD/YYYY - Output DD/MM/YYYY then nicelabel is reading the date as MM/DD/YYYY HH:mm:ss which I couldn't set up as picture.
Solution: I added a function of type "Subset" with a length of 10.
This way the time stamp got chopped off and the Input format - Output format on the validation tab did the conversion to DD/MM/YYYY for me (using the subset for my label).
Hope that helps other people.
Cheers
Markus
The problem seems to be that if you format the variable as date and try to use Input MM/DD/YYYY - Output DD/MM/YYYY then nicelabel is reading the date as MM/DD/YYYY HH:mm:ss which I couldn't set up as picture.
Solution: I added a function of type "Subset" with a length of 10.
This way the time stamp got chopped off and the Input format - Output format on the validation tab did the conversion to DD/MM/YYYY for me (using the subset for my label).
Hope that helps other people.
Cheers
Markus
Re: Date format
Hello. You wrote: I added a function of type "Subset" ...
What does subset did you use?
Can you give it?
What does subset did you use?
Can you give it?