Date Format Issue

[JustinRamsey]

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,

[dplr-rn · Accepted solution]

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

[ziadm · Accepted solution]

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.

[JustinRamsey]

Thank You!!! That worked! v

[dplr-rn]

Great. Please mark as answered and close the thread