Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
wanyunyang
Creator III
Creator III

Qlik sense data format

Hi guys,

What are the differences between date formatting functions like Date(), Date#(), Timestamp(), Floor(), etc.? What should the input and output date formats be?

Thanks for help! 

1 Solution

Accepted Solutions
Thiago_Justen_

Let's try to make it easier:

functions followed by hashtag are functions of interpretation. For example: date # is a function that interprets a text as a date field.


But it's better than my explanation if you could read this:


https://help.qlik.com/pt-BR/sense/November2017/Subsystems/Hub/Content/Scripting/InterpretationFuncti...


A good way to learn about it is read and read Qlik Help.


Here it is a good documentation about Qlik's functions - https://help.qlik.com/en-US/sense/1.1/pdf/Script%20Syntax%20and%20Chart%20Functions%20Guide.pdf



Cheers

Thiago Justen Teixeira Gonçalves
Farol BI
WhatsApp: 24 98152-1675
Skype: justen.thiago

View solution in original post

1 Reply
Thiago_Justen_

Let's try to make it easier:

functions followed by hashtag are functions of interpretation. For example: date # is a function that interprets a text as a date field.


But it's better than my explanation if you could read this:


https://help.qlik.com/pt-BR/sense/November2017/Subsystems/Hub/Content/Scripting/InterpretationFuncti...


A good way to learn about it is read and read Qlik Help.


Here it is a good documentation about Qlik's functions - https://help.qlik.com/en-US/sense/1.1/pdf/Script%20Syntax%20and%20Chart%20Functions%20Guide.pdf



Cheers

Thiago Justen Teixeira Gonçalves
Farol BI
WhatsApp: 24 98152-1675
Skype: justen.thiago