topic Re: getfieldselection date value in App Development

getfieldselection date value

alanwong1178 — Sat, 16 Nov 2024 00:27:27 GMT

Hi All,

I would like to use getfieldselection in set analysis. I have looked for solution in community to turn to date mmmdd format as below. But it doesn't work

date#(GetFieldSelections([orderdate]),'MMMdd')

like order date = 10/21/2021, 11/27/2021 , I would like to get Oct21 , Nov27

Re: getfieldselection date value

salonicdk28 — Thu, 11 Mar 2021 07:43:35 GMT

Hi,

Please try using this-

=Date(GetFieldSelections([orderdate]),'MMMDD')

Re: getfieldselection date value

Vegar — Thu, 11 Mar 2021 08:22:47 GMT

The GetfieldSelections() returns a string describing your selection, it does not return an array of values. It will be hard to format each of these, there is also a default limit to the amount of selection listed before it starts to return "X out of 1234".

I suggest you either create a field with the format 'MMMDD' and do the selections on that field. Or if the check for selection not important, but you just want a list of available values then you could use concat() instead. Maybe like this?

=concat(Distinct Date([orderdate],'MMMDD'), ', ')