Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
if(paymentDate >= date($(SelectDateFrom),'MM-DD-YYYY'), True, False)
PaymentDate=15-06-2017
SelctedDateFrom=01-06-2017
But output is showing false please suggest the correct syntax to get the exact output
Hello!
Is this format "MM-DD-YYYY" suitable for such values 15-06-2017?
Hi manoj217,
Try '$(SelectedDateFrom)' and SelectedDateFrom instead of $(SelectedDateFrom) of maybe even $(=SelectedDateFrom). That can give different results.
Maybe it is because PaymentDate is with or without the capital P. But that is just a guess based on the different ways you wrote paymentDate.
Also you use: SelectDateFrom and SelctedDateFrom in your post. Maybe that is also wrong in you application.
Try this
If(paymentDate >= Date#($(SelectDateFrom), 'MM-DD-YYYY'), True, False)
or this
If(paymentDate >= Date#('$(SelectDateFrom)', 'MM-DD-YYYY'), True, False)
Try this, in my case it worked.
=if(PaymentDate>= date('$(SelectedDateFrom)'), True(), False())
hi,
you should format the "SelectDateFrom" as 'DD-MM-YYYY'.
Sorry i gave an example only.
consider
paymentdate =06-15-2017
selecteddatefrom=06-01-2017
not working every time it is showing false only