Find Min Date without Load

[JustinDallas]

Hello Folks,

I need to find and set the minimum date of a field to a value.

LET vCustomerStartDate = ...

I've tried something like 

LET vCustomerStartDate = MIN([Order Ship Date])

but that value is always null.  I keep feeling like I need something like Peek, FieldValue and Min, but many of those are based on the load order of the records.

Any help is greatly appreciated.

[Channa]

try rangemin(date)

[JustinDallas]

No dice, 

LET vCustomerStartDate2 = RangeMin([Order Ship Date])
;

Still gives me <NULL>.

[felipe_dutra]

Tab:
Load
Min([Order Ship Date]) as MinOSD
Resident XXXX;

LET vCustomerStartDate = Peek('MinOSD', -1, 'Tab');
Drop table Tab;

[emrekaya]

is there any possibility that your dimension is in the string form? maybe you can try to convert your dimension "order ship date" into numbers then you can use your min formula. After that you can convert your number to date.