Date format

This forum is for questions regarding the forums and for all your non-NiceLabel ideas. Well... maybe not all of them ;-)

Moderators: Georges, milos

Post Reply
Massimo
Enthusiast
Posts: 18
Joined: Fri Oct 08, 2010 5:23 pm

Date format

Post by Massimo » Fri Oct 08, 2010 5:39 pm

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

Rsas
NiceLabel
NiceLabel
Posts: 305
Joined: Tue Oct 24, 2006 3:20 pm
Location: Kranj, Slovenia
Contact:

Re: Date format

Post by Rsas » Tue Oct 12, 2010 9:12 am

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.
Regards,

Sasa
Pre-sales Specialist

Massimo
Enthusiast
Posts: 18
Joined: Fri Oct 08, 2010 5:23 pm

Re: Date format

Post by Massimo » Tue Oct 19, 2010 8:32 pm

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

Hereiam
Newcomer
Posts: 1
Joined: Fri Oct 11, 2013 5:13 am

Re: Date format

Post by Hereiam » Fri Oct 11, 2013 5:22 am

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

darjab
Addict
Addict
Posts: 118
Joined: Tue Oct 07, 2014 2:38 pm

Re: Date format

Post by darjab » Mon Nov 24, 2014 10:00 pm

Hello. You wrote: I added a function of type "Subset" ...
What does subset did you use?
Can you give it?

Post Reply