This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
My date format is of MM/DD/YYYY HH:MM:SS
want to convert it into normal DD/MM/YYYY
How to achieve this..can anyone help me out
Thanks in Advanced
in your load script use
Date(Date#(YourValue, 'formatASis'), 'DesiredFormat')
This is assuming your date value is not really date but text. However, if you have a value which is really a date value (numeric values at the backend), you could just use outer date() and leave out date#().
i think it's best that you change the format from the system variables in the first page and then just simply use date(your_field).
Why? Because you may come across many Date Fields with different formats and when you are using them for expressions you may have problems getting the right expression with it's proper values.
hope it helps,
first set date format in main script :
Use following code in your load script
load Date(Your_Date_Column_Name,'DD/MM/YYY') from your [Path]