Which are the functions used to convert string date to date format in Qlikview?

qlikview
format
data_wrangling

#1

Hi,

I have date available in string format in Qlikview. Now I want to use them as date and want to apply date function to these also like year, month. Can you help me to convert these strings into date format?

Regards,
Satish


#2

@Satish

Function Date#() returns the expression as a date according to the string given as format-code. If the format code is omitted, the default date format set in the operating system is used.

Syntax:-

Date# (text [, format])

After that use Date function to convert it to date. Let’s look at below example:-

Example:-

=Date(Date#('16JAN2014','DDMMMYYY'))

Above we have converted character format of date to date using date# and date functions.

Regards,
Sunil