Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a date field by the name DTM in my app, on searching for a particular date in list box i am able to find the field only after using '*' as shown in the attached.
I am using this field in a set expression and it is not returning values for matching DTM field value.
= Only({1< DTM = {"$(=vCurrentDt)"} >} Month)
so i decided to change the format of the field to date and that is providing error in expression.
= Only({1< date(DTM) = {"$(=vCurrentDt)"} >} Month)
I there any way that we can achieve this by making changes in application only and not data model.
Thanks,
Ganesh
What is vCurrentDt?
Hi Sunny,
The variable expression given below
vCurrentDt=if(GetSelectedCount(WorkingWeek2)=1,date#(date(WorkingWeek2+5),'M/D/YYYY'),num(Today()))
Not entirely sure, but may be this
=Only({1<DTM = {"=DTM = vCurrentDt"}>} Month)
OR
=Only({1<DTM = {"=DTM = $(vCurrentDt)"}>} Month)