Solved: How load date YYYY-MM - Qlik Community

irmantas · ‎2018-01-22

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???

andrei_delta · ‎2018-01-22

hi,

this is the sql command for getting YYYY-MM from current time : convert(varchar(7), getdate(), 126)

View solution in original post

Chanty4u · ‎2018-01-22

what is the Invoice date format?

Chanty4u · ‎2018-01-22

you can try this

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

irmantas · ‎2018-01-22

YYYY.MM.DD hh:mm:ss

Chanty4u · ‎2018-01-22

try

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

irmantas · ‎2018-01-22

I got error:

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

Chanty4u · ‎2018-01-22

used invoice date only right?

Anil_Babu_Samineni · ‎2018-01-22

My option is this?

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

irmantas · ‎2018-01-22

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

irmantas · ‎2018-01-22

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