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: 
claudialet
Contributor III
Contributor III

Date function on timestamp - field not recognized by Date Picker extension ?

  Here is the date value in Excel : 

06/13/2019 02:35 PM 

 

Here is the auto generated load script : 

Timestamp(Timestamp#([Date], 'MM/DD/YYYY hh:mm TT') ) AS [Date]

 

I am trying to use this in Date Picker but it is not auto detected as a date field even if I format it  as  'MM/DD/YYYY' in the properties. 

I tried the following but no solution !

 

Date(Date#([Date ],'MM/DD/YYYY h:mm'),'MM/DD/YYYY')

Date(Date#floor(Timestamp(Timestamp#([Date], 'MM/DD/YYYY hh:mm TT') )) 'MM/DD/YYYY') AS [Date]

 

Any ideas ?

 

 

1 Solution

Accepted Solutions
sunny_talwar

Not sure, but try this

Date(Floor(TimeStamp#([Date], 'MM/DD/YYYY hh:mm TT'))) as [Date]

View solution in original post

2 Replies
sunny_talwar

Not sure, but try this

Date(Floor(TimeStamp#([Date], 'MM/DD/YYYY hh:mm TT'))) as [Date]
claudialet
Contributor III
Contributor III
Author

 Yes ! It worked ! 🙂