Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Date concatenation

hi,

in expression edit, i want to concatenate date dim such as dd/mm/yyyy

what's about this code?

I use qlikview expression but it displays error

Yours faithfully

2 Replies
martin59
Specialist II
Specialist II

if you have a field with a date format, you have just to write :

date(MyDateField,'DD/MM/YYYY')


if it's a date in text format :

date#(MyDateField,'DD/MM/YYYY')


if you have three fields (year, month and day) :

makedate(YearField,MonthField,DayField)


suniljain
Master
Master

date(Makedate(Add Parameter Here))