Qlik

[Sureshbabukapu]

Hello, 

My self suresh iam beginner in qlikview. 

I have situation here... I have a field called DOC_DT in timestamp format now I have to change it to DD/MM/YYYY format 

Any suggestions please

[Vegar]

If your DOC_DT is recognised as a timestamp then you just need to converting it to a date format.

You can achieve this with this formula.

dayname(DOC_DT) as [Document date]

The output will be a date in your application default date format. If that is not DD/MM/YYYY then you will need to format your date as well. Then try this.

date(dayname(DOC_DT), 'DD/MM/YYYY') as [Document date]

[anat]

date(floor(DOC_DT), 'DD/MM/YYYY')