Get a record issue with date format (Fin & Ops)

(0) Share

Report

Posted on by ConsultantIT

110

Hi,

I have issues to get a record from F&O, because the entity I use requires 3 keys (2 of them are dates), and I don't know how to write the good format date to get results.

Here are screenshots:

I used many things, here are just two examples:

the first one to see the keys:

Here, I tried to format the dates (one of my many attempts):

Here is the data I expect to be returned:

Thanks for your help

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Expiscornovus 33,175 Most Valuable Professional on at

Like (1)

Report
Re: Get a record issue with date format (Fin & Ops)

Hi @Frog64,

Could you as a workaround use the List records and add some filters to the filter query field. Like for instance PositionId
PositionId eq 'Consultant1'
Edit: DataAreaId doesn't work for this filter.

Was this reply helpful? Yes No
ConsultantIT 110 on at

Like (1)

Report

Re: Get a record issue with date format (Fin & Ops)

Thanks, I can move forward by doing this. Now I have new question but I will create a new post 🙂
Thanks!

Was this reply helpful? Yes No