Trying to search for all planned start dates that are 14 days old.
I can search using >TODAY but cant find out what other functions i could use to search for dates without actually using dates. Can’t use “Yesterday” or “Last Week”
if i do try one of those i get the following value
Page 1 / 1
Dear jbernardo,
where are you trying to search? In the Search Menu? Lobby? Business Rule?
Mostly you can use the SQL Possibilities. For Lobbys there are specific Parameters that can be used.
Best regards
Hi @Jacqueline.Lyra
Anytime a user is trying to search for something. In this example want to look at what was created on (2 weeks ago for example)
i can put >TODAY but i cant put anything else as it wants a DateTime
jbernardo,
Weird that that seems to be the only one reacting. However >now performs the same (most likely the current time is also part of the selection).
Sorry of being of no real help,
Steve
Honestly not an expert in aurena or mobile but I would expect the same substitution variables from the enterprise explorer to work there.
are you familiar with the substitution variables in EE?
JULIAN,
This is an FSM question. It seems that IFS has not, yet, come to the stage that the search options are build the same way in FSM and IFS Applications (be it EE or Aurena).
Help text of FSM reveals nothing at this moment (or I missed it).
Regards,
Steve
try them
They are working for me in FSM 6 Update 4 but also should work in older versions.
TODAY
TOMORROW
YESTERDAY
START_OF_THIS_WEEK
START_OF_NEXT_WEEK
START_OF_LAST_WEEK
START_OF_THIS_MONTH
START_OF_NEXT_MONTH
START_OF_LAST_MONTH
START_OF_THIS_YEAR
START_OF_NEXT_YEAR
START_OF_LAST_YEAR
END_OF_THIS_WEEK
END_IF_NEXT_WEEK
END_OF_LAST_WEEK
END_OF_THIS_MONTH
END_OF_NEXT_MONTH
END_OF_LAST_MONTH
END_OF_THIS_YEAR
END_OF_NEXT_YEAR
END_OF_LAST_YEAR
As you mentioned that Yesterday isn’t working, it’s working in my system:
I tried following example:
Most likely it is version related. We are using FSM6 Update 2 and I get the following:
It could has to do also with this column definition. Try it with created
Apperently not:
Left the Planned Start blank and filled the Created field.
try them
They are working for me in FSM 6 Update 4 but also should work in older versions.
TODAY
TOMORROW
YESTERDAY
START_OF_THIS_WEEK
START_OF_NEXT_WEEK
START_OF_LAST_WEEK
START_OF_THIS_MONTH
START_OF_NEXT_MONTH
START_OF_LAST_MONTH
START_OF_THIS_YEAR
START_OF_NEXT_YEAR
START_OF_LAST_YEAR
END_OF_THIS_WEEK
END_IF_NEXT_WEEK
END_OF_LAST_WEEK
END_OF_THIS_MONTH
END_OF_NEXT_MONTH
END_OF_LAST_MONTH
END_OF_THIS_YEAR
END_OF_NEXT_YEAR
END_OF_LAST_YEAR
As you mentioned that Yesterday isn’t working, it’s working in my system:
Unfortunately none work in FSM 5.7 :(
try them
They are working for me in FSM 6 Update 4 but also should work in older versions.
TODAY
TOMORROW
YESTERDAY
START_OF_THIS_WEEK
START_OF_NEXT_WEEK
START_OF_LAST_WEEK
START_OF_THIS_MONTH
START_OF_NEXT_MONTH
START_OF_LAST_MONTH
START_OF_THIS_YEAR
START_OF_NEXT_YEAR
START_OF_LAST_YEAR
END_OF_THIS_WEEK
END_IF_NEXT_WEEK
END_OF_LAST_WEEK
END_OF_THIS_MONTH
END_OF_NEXT_MONTH
END_OF_LAST_MONTH
END_OF_THIS_YEAR
END_OF_NEXT_YEAR
END_OF_LAST_YEAR
As you mentioned that Yesterday isn’t working, it’s working in my system:
we will chalk this up to an version issue. Thanks everyone!
@jbernardo,
Just seen this from last month.
Surprisingly its in the reference guide, the one I have for FSM5.7U11 is on Pg14. Look for Search Variables. But I have a Lobby that navigates to the Task screen with a pre-determined search.
Basically it loads the task screen with these in the date fields.
So if you were to have the created on search value have >today.AddDays(-14) that will give you the last 2 weeks of data.
Regards
Ady
@jbernardo,
Just seen this from last month.
Surprisingly its in the reference guide, the one I have for FSM5.7U11 is on Pg14. Look for Search Variables. But I have a Lobby that navigates to the Task screen with a pre-determined search.
Basically it loads the task screen with these in the date fields.
So if you were to have the created on search value have >today.AddDays(-14) that will give you the last 2 weeks of data.
Regards
Ady
Yes this works! Thank you. Wish i could change this to the “Best Answer”
Much apprecaited!
<Now.AddDays(-14) is what you are looking for
also I include this document from Reference doc with some adaptations of my own
<Now.AddDays(-14) is what you are looking for
also I include this document from Reference doc with some adaptations of my own
This is amazing and a HUGE help
thank you so much!
@jbernardo,
Just seen this from last month.
Surprisingly its in the reference guide, the one I have for FSM5.7U11 is on Pg14. Look for Search Variables. But I have a Lobby that navigates to the Task screen with a pre-determined search.
Basically it loads the task screen with these in the date fields.
So if you were to have the created on search value have >today.AddDays(-14) that will give you the last 2 weeks of data.
Regards
Ady
Yes this works! Thank you. Wish i could change this to the “Best Answer”