Help needed! How to convert a date from 38720 to 3/01/2006
Because Qlikview is working with numeric values you could better use a numeric date value for your master calendar. For presentation you could use a formatted field but for calculations in your script a numeric value is the best solution (best performance)! Every Qlikview date function use the numeric format, for example: "month(38720)".