Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
apthansh
Creator
Creator

Date function is not working.

Below expression in list box is not working.

=if(DATE([Expiration Date],'MM-DD-YYYY') >'09-01-2016',[Expiration Date])

Not suure why

Thank you.

1 Solution

Accepted Solutions
sunny_talwar

Try this:

=if([Expiration Date] > MakeDate(2016, 9, 1), [Expiration Date])

View solution in original post

13 Replies
sunny_talwar

Try this:

=if([Expiration Date] > MakeDate(2016, 9, 1), [Expiration Date])

sdmech81
Specialist
Specialist

Is ur ([Expiration Date], a date .Add list box and see..If its falling ryt panel then yes..If at left pane then use first Date# and then proceed..

Sachin

sdmech81
Specialist
Specialist

upon cross verify,

Sunny's expression should work

Sachin

apthansh
Creator
Creator
Author

Thnak you sunnyy..That worked...

how can I put the same in sheet trigger ?

apthansh
Creator
Creator
Author

I gave the below in select in field.Not working

='>=' & MakeDate(2016, 9, 1)

sunny_talwar

May be like this:

Field

[Expiration Date]


Search String

='>=' & Date(MakeDate(2016, 9, 1), 'DateFieldFormatHere')

Make sure to use the date field format of Expiration Date to replace DateFieldFormatHere

sunny_talwar

You need to give the right date format here

apthansh
Creator
Creator
Author

You are awesome....my hero

sunny_talwar