Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
How can we use a date range expresson inside p() .
Currently i am using the below expression which is not working:-
MachineName=p({<Date={">=$(=date(floor(monthstart(addmonths(today()-4))),'DD-MM-YYYY'))"}*{'<$(=date(floor(monthstart(addmonths(today()-1))),'DD-MM-YYYY'))"} )
HI,
Try like this
MachineName=p({<Date={">=$(=date(floor(monthstart(today(),-4)),'DD-MM-YYYY'))<$(=date(floor(monthstart(today(), -1)),'DD-MM-YYYY'))"} )
Hope this helps you.
Regards,
Jagan.
Hi,
May be like this,
=Only({<MachineName=P({< Date={">=$(=Date(Max(Date)-3))<=$(=Date(Max(Date)))"}>}MachineName)>}MachineName)
or
=Only({<MachineName=P({<Date={">=$(=Date(Today()-3))<=$(=Today())"}>MachineName)>}MachineName)
Hope this Helps,
Hirish
Hi Hirsh,
can the above expression be included within an expression ?
i tried it but it is giving an error.
Tried it but not working jagan.
Make sure that your Date Field is in proper date format, try below
MachineName=p({<Date={">=$(=date(monthstart(addmonths(today(),-4))))<=$(=date(monthstart(addmonths(today(),-1))))"} )
Hi,
Your Data is Current or not?
if Current Go for Second expression, else go with First one,
Can you make a sample app with a sample data.That way we can see the issue!
-Hirish
it is in a proper date format still the expression is not working
Can you share what is the format that you date field is in?
i checked with 2 formats-
date(Date,'MM/DD/YYYY')
and
date(Date,'MM/DD/YYYY hh:mm:ss')