Trouble with format dates

[pgalvezt]

Hi, I have 2 dates ActualDate and LastDate. With both dates i want to get an incremental reload with Qvds Files. Until now everything is fine but, in my access data appear ActualDate with 2 formats example: 21/03/2011 -> March 21(this is the correct format) and the other one 04-06-2011 -> June 04, Ithink Should be April 06(I think we are not at this time ). How can I get that QlikView read 04/06/2011-> April 06?

Thanks,

[Miguel_Angel_Baeyens]

Hi,

Interpretation and representation in QlikView for money, decimal and thousand separators, dates, etc, is subject to your computer's regional settings. According to that, if you go to your script editor, main tab, the first lines are the environment variables that tell QlikView how to interpret and represent, in this file, those formats.

If you cannot change that format in the source, you will need to change these variables to fit the source, kind of

SET DateFormat='MM/DD/YYYY';
SET TimestampFormat='MM/DD/YYYY h:mm:ss[.fff]';

Obviously, this settings are document wide, and they will affect to any other date you have.

Hope that helps.

[pgalvezt]

You´re right something in my code was wrong but with your example everithing its clear Thank you Both of you guys.