Skip to main content
Announcements
Global Transformation Awards submissions are open! SUBMIT YOUR STORY
cancel
Showing results for 
Search instead for 
Did you mean: 
mahnoor1279
Contributor III

Correct format of date of Qliksense used in postgresql query

hey everyone ive some script written on postgresql and i want to get date wise data in Qliksense ,

ive also used variable but its not working and gives error of  incorrect date format 

here is the format for variable

mahnoor1279_0-1661770746888.png

 

mahnoor1279_1-1661770783011.png

 

Labels (3)
1 Reply
ajaykakkar93
Specialist III

hi,

i suggest you to check the default format coming in qlik sense for the field or can try below code 
date(date#( floor(dateField) , 'DATE FORMAT'))

Please mark the correct replies as Solution. Regards, ARK
Profile| GitHub|YouTube|Extension|Mashup|Qlik API|Qlik NPrinting