topic Re: Date Format Issue in QlikView

Date Format Issue

JustinRamsey — Wed, 25 Nov 2020 16:16:04 GMT

Good Afternoon,

I am having an issue with the format of dates. The table import from SAP into Qlik has the dates formatted YYYY-MM-DD. For the reports I am building I only care about the month and year and I would like the dates to be formatted MM-YYYY. The field Im interested in is VBAK.ERDAT. The line loading code I have attempted is below and has not worked. The date is still being imported as YYYY-MM-DD. Any suggestions?

VBAK.ERDAT,
Date(Date#(VBAK.ERDAT,'YYYY-MM-DD'),'MM_YYYY') as CreatedOn,

Re: Date Format Issue

dplr-rn — Mon, 25 Feb 2019 19:12:47 GMT

try
date(monthstart(VBAK.ERDAT), 'MM-YYYY')

Re: Date Format Issue

ziadm — Mon, 25 Feb 2019 19:55:42 GMT

what is the return value of Num(Date#(VBAK.ERDAT,'YYYY-MM-DD')) .. if its not a date range number of 5 digits ( 43521 for today) , then you are reading a wrong date format from the DB .. Try to get the correct date format from the DB.

Re: Date Format Issue

JustinRamsey — Mon, 25 Feb 2019 20:43:45 GMT

Thank You!!! That worked! v

Re: Date Format Issue

dplr-rn — Mon, 25 Feb 2019 20:58:49 GMT

Great. Please mark as answered and close the thread