QlikView has an intelligent algorithm to recognize dates independently of which region you are in. In most cases, you will have no problems loading them. It just works and you do not need to think about it. However, in some cases dates are not properly recognized and then you need to add some code in the script to make it work.
and a table with sales in 2012 up to september 2013, with TransactionDate as the field containing the date of the transaction
inyeartodate(vDate,TransactionDate,0) will return you true(), aka -1 for all the lines with TransactionDate<=vDate and TransactionDate>=yearstart(vDate)
=> you can get sales from the begining of the year until vDate with a formula like this:
.png "Former Employee"){kind=icon}
