If the input column is in the last four months then X then Y

jpradeep.net · Post by **jpradeep.net** » Tue Dec 07, 2010 6:21 am

I have an input column and its datatype is integer. the source data is in the format of '20100823'.It means 2010(Year),08(month),23(Date).

My question is if the input column is in the last four months then it is X and if not then it is Y. Here we need to consider the year also.

anbu · Post by **anbu** » Tue Dec 07, 2010 9:59 am

Code: Select all

svYYYY_MM=DsJobStartTimestamp[1,7]
svYear=svYYYY_MM[1,4]
svMon=svYYYY_MM[6,2]
inp='20100823'
svInpYear=inp[1,4]
svInpMon=inp[5,2]

If (svYear - svInpYear)*12 + svMon - svInpMon <= 4 Then 'X' Else 'Y'

jpradeep.net · Post by **jpradeep.net** » Wed Dec 08, 2010 5:08 am

Thanks a lot Anbu

jpradeep.net · Post by **jpradeep.net** » Wed Dec 08, 2010 5:09 am

"DsJobStartTimestamp[1,7]" means current timestamp?

chulett · Post by **chulett** » Wed Dec 08, 2010 8:04 am

It means the first 7 characters from the output of the DSJobStartTimestamp macro, which is a constant that is the date/time that the job started.