I have a problem with Calendar Variable which it is an extension from Qlik Branch (Qlik Branch). the date format is DD/MM/YYYY, and in my project I need to add the time (DD/MM/YYYY hh:mm:ss).
How can I do that? moreover, In some queries I need a fixed time I mean for example the From Date: (DD/MM/YYYY 00:00:00) and and for the To Date (DD/MM/YYYY 23:59:59). I tried to add the time (00:00:00) in a new variable but the problem the date converted to a number and the value appear like [for example ] (00994568415 00:00:00). Please see the attached pic for more explanation.