and more in a single search tool across platforms. Read the announcement here. |
05/03/2023 04:35 AM
Hi All,
In Success Factor User Import query we are trying to fetch only those users in the query who will join in future that means hire date is greater than equal to current date.
For that we used below highlighted format but this didn't worked, can anyone please help in this.-
employmentNav/startDate>=date(cur(date))
Thanks,
Jaya Karothia
05/03/2023 06:46 AM
Hi @Jaya
Use the below format and try ( format it accordingly how the startdate is coming )
(new Date()).format('yyyy-MM-dd')
Thanks
Darshan
05/03/2023 06:52 AM - edited 05/03/2023 06:53 AM
Hi Darshan,
From success factor it is coming in epoch format, how can we convert date into epoch - any idea?
Thanks,
Jaya karothia
05/03/2023 07:29 AM - edited 05/03/2023 09:38 AM
you can use it as below and format it accordingly
startDate+gt+'${new Date().format('yyyy-MM-dd')}. ( this should work it internally calculates )
Note: if you are in 3.11 version and above instead of new Date you can use Calendar.getinstance like below
${Calendar.getInstance().getTime().format('yyyy-MM-dd')
Thanks
Darshan
05/03/2023 07:56 AM
Hi Darshan,
Getting below error msg
Thanks,
Jaya karothia
05/03/2023 07:59 AM
IN postman you cannot use new date directly, the saviynt system calculates it, you need to use it saviynt and try to run the job. ( you can give hard code values in postman incase to validate )
Thanks
Darshan
05/03/2023 11:01 PM
Not working in Saviynt too, see below error msg-
Thanks,
Jaya Karothia
05/04/2023 03:08 AM
Hi @Jaya
This looks like a syntax issue ( illegal character -486 ) check if it is near new date format try removing the invited commas in the Api call and try. if not check where the Api url is going wrong.
Also as just said above, if you are using the version 3.11+ and above instead of new date use calendar date time instance.
Thanks
Darshan
Thanks
Darshan