topic Re: Set Analysis : getfieldselections with date -1 in App Development

Set Analysis : getfieldselections with date -1

sass — Sat, 16 Nov 2024 04:32:47 GMT

Hello,

I am trying to get set analsyis to give me the day before selected day by user.

I tried this but it doesn't work...

Sum({<MasterCal.Day={"=$(=GetFieldSelections(MasterCal.Day))-1"}>} sales)

Can any one fix this please.

asinha1991 — Fri, 27 Sep 2019 10:21:28 GMT

getfieldselections return string

you need convert it to date, for example date#(GetFieldSelections(MasterCal.Day),'mm/dd/yyyy')

format should be what your actual date format is

sass — Fri, 27 Sep 2019 10:44:04 GMT

Thanks for the suggestion !

I have tried this :

Sum({<[MasterCal.Day]={"=$(=date#(GetFieldSelections([MasterCal.Day]),'mm/dd/yyyy')"}>} sales)

But it doesnt work...

asinha1991 — Fri, 27 Sep 2019 10:47:59 GMT

can you try this

date#(GetFieldSelections([MasterCal.Day]),'mm/dd/yyyy') in a textbox and see what it returns?

maybe GetFieldSelections([MasterCal.Day]) returns a date which is not in 'mm/dd/yyyy' format?

sass — Fri, 27 Sep 2019 10:52:57 GMT

date#(GetFieldSelections([MasterCal.Day]),'mm/dd/yyyy') in a textbox return a correct date...

asinha1991 — Fri, 27 Sep 2019 12:25:41 GMT

need to see whats wrong with set analysis then but you can give this a try in the mean time

Sum({<[MasterCal.Day]=}>} if({MasterCal.Day=date#(GetFieldSelections([MasterCal.Day]),'mm/dd/yyyy')-1,sales))

sass — Mon, 30 Sep 2019 08:31:00 GMT

Doesn't work...

When I try this it works :

Sum({<[MasterCal.Day]={'$(=GetFieldSelections([MasterCal.Day]))'}>} sales)

Sum({<[MasterCal.Day]={'$(=max([MasterCal.Day]))'}>} sales)

When I want to add -1, it doesn't work...

If anyone has a solution....