Month and year returning null value?

[MustafaAbdelhaq]

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

[AskoLötjönen]

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

[MustafaAbdelhaq]

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

[AskoLötjönen · Accepted solution]

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

[MustafaAbdelhaq]

Much appreicated

Thank you so much