Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Please try using this-
=Date(GetFieldSelections([orderdate]),'MMMDD')
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'), ', ')