topic Re: Month and year returning null value? in SAS Web Report Studio

Month and year returning null value?

MustafaAbdelhaq — Wed, 10 Jun 2015 07:49:28 GMT

Hello,

I have a table that contains a date column, with the following details :

Name : BILL_DATE

Type : Date

Length : 8

Format : DATETIME20.

Informat : DATETIME20.

Label : BILL_DATE

I'm trying to retrieve the month value of each row, so I'm using the computed column advanced expression with the following statement ; month(t1.BILL_DATE)

The results are Null, any ideas why this might me happening?

while on the other hand the statement datepart(t1.BILL_DATE) is returning normal values!

Thank you

Re: Month and year returning null value?

AskoLötjönen — Wed, 10 Jun 2015 08:08:02 GMT

Month -function is assuming that there is date as a input.

Re: Month and year returning null value?

MustafaAbdelhaq — Wed, 10 Jun 2015 08:40:04 GMT

Ok, and how can I fix this? is there a walk-around or something?

Re: Month and year returning null value?

AskoLötjönen — Wed, 10 Jun 2015 08:49:03 GMT

You have to take datepart first : month(datepart(bill_date))

Re: Month and year returning null value?

MustafaAbdelhaq — Wed, 10 Jun 2015 10:26:20 GMT

Much appreicated

Thank you so much