Page 1 of 1

Defaulting the century when use StrinToTrimStamp

Posted: Sat Feb 28, 2009 7:11 pm
by Derrickfn
I have a date in the format of yymm, It there anyway of getting the StringToTimestamp function to default the century properly. When you don't specify the century, it always uses 19. If the year part is greater than 50 I would want it to use 19. Otherwise it should use 20.

StringToTimestamp(DSLink4.fd1,"%yy%mm")

Using a transformer is there a quick and easy way of making it do the right thing.

Posted: Sun Mar 01, 2009 8:54 am
by chulett
That's controlled by CENTURYPIVOT - seach here and in the documentation for the details of its usage.