date - 1 day transformationm
Posted: Mon Aug 12, 2013 12:11 pm
Hi,
My dates are coming as varchar format as 20100503 i want to "%yyyy%mm%dd" and do -1 day too somehow -1 day is not working in syntax below please advise.
Thanks
IF IsValid("date", DSLink19.HRP1001_BEGDA -1, "%yyyy%mm%dd")
THEN StringToDate(DSLink19.HRP1001_BEGDA -1 ,"%yyyy%mm%dd")
ELSE StringToDate("00000101","%yyyy%mm%dd")
My dates are coming as varchar format as 20100503 i want to "%yyyy%mm%dd" and do -1 day too somehow -1 day is not working in syntax below please advise.
Thanks
IF IsValid("date", DSLink19.HRP1001_BEGDA -1, "%yyyy%mm%dd")
THEN StringToDate(DSLink19.HRP1001_BEGDA -1 ,"%yyyy%mm%dd")
ELSE StringToDate("00000101","%yyyy%mm%dd")