Date function is not working.

[apthansh]

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.

[sunny_talwar · Accepted solution]

Try this:

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

[sdmech81]

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]

upon cross verify,

Sunny's expression should work

Sachin

[apthansh]

Thnak you sunnyy..That worked...

how can I put the same in sheet trigger ?

[apthansh]

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]

You are awesome....my hero

[sunny_talwar]