How load date YYYY-MM

[irmantas]

Hello all,

From SQL I am loading  data like this :

Year(INVOICEDATE) as Year,

Month(INVOICEDATE) as Month,

Day(INVOICEDATE) as Day,

But i need load field like this : YYYY-MM

I was try :Year(INVOICEDATE)&'-'& Month(INVOICEDATE) as YearMonth,

But result is 0

Is it posable???

[Chanty4u]

what is the  Invoice date format?

[Chanty4u]

you can try this

Date(monthstart(Date), 'YYYY-MM')  as MonthYear

[irmantas]

YYYY.MM.DD hh:mm:ss

[Chanty4u]

try

Date(InDate,'YYYY-MM')  as YearMonth

[irmantas]

I got error:

'Date' is not a recognized built-in function name.

[Chanty4u]

used invoice date only right?

[Anil_Babu_Samineni]

My option is this?

Date(Date#(INVOICEDATE,'YYYY.MM.DD hh:mm:ss'), 'YYYY-MM')

[irmantas]

Date(INVOICEDATE,'YYYY-MM')  as YearMonth

[irmantas]

Error: 'Date#' is not a recognized built-in function name