Hi,
I am trying to convert varchar(8) to date and also doing DateOffsetByDays below is syntax but transformer not liking DateOffsetByDays
Thanks
IF IsValid("date", DateOffsetByDays(to_trans4.S_AAA, "%yyyy%mm%dd",1))
THEN StringToDate(to_trans4.S_AAA,"%yyyy%mm%dd")
ELSE StringToDate("99990101","%yyyy%mm%dd")
date issue
Moderators: chulett, rschirm, roy
The DateOffsetByDays() function needs a date input parameter, which wouldn't work if your source column isn't a valid date.
Try
(I might have a syntax error in there, but you should get the gist of it).
Try
Code: Select all
IF IsValid("date", to_trans4.S_AAA, "%yyyy%mm%dd")
THEN DateOffsetByDays(StringToDate(to_trans4.S_AAA, "%yyyy%mm%dd"),1)
ELSE StringToDate("99990101","%yyyy%mm%dd")
Unfortunately, all this means is that they were Premium at one point - not that they are currently. They've let it expire.ArndW wrote:your userid shows as a "premium member" here on the forum.
I've asked for this in the past to be changed to show one's current status but I don't think those kind of changes to the existing forum code are possible.
![Sad :(](./images/smilies/icon_sad.gif)
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers