I have a couple of virtuals that disappear when I change my column type (Employee) from Name to a ref or enum. They are select expressions in the virtuals as follows:
SELECT(Shift Day[Shift Date],
AND([Name]=[_THISROW].[Employee],
[Shift Date]>=[_THISROW].[Start Date],
[Shift Date]<=[_THISROW].[End Date]))
They come back as valid in both cases. Not sure if this is result of changing the column type from static to dynamic, but enum would be static as well.
I went to support and now Iโm back to this forum.
I would like to change the column type to a ref, butโฆ
Much appreciated if anyone has an answerโฆThanks!!
LinkedIn
Twitter
