topic Re: Date(Date#() in QlikView

Date(Date#()

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

Can anyone please explain the below functions for me

DATE(DATE#MID(FILENAME(),23,10),'YYY_MM_DD'),'M/D/YYYY')

Floor(Monthend()

Thank you

MarcoWedel — Thu, 12 Jul 2018 20:49:06 GMT

DATE(DATE#(MID(FILENAME(),23,10),'YYYY_MM_DD'),'M/D/YYYY')

extracts a date from the name of the file this expression is loaded from, starting from its 23rd character.

Floor(Monthend(SomeDateOrTimestamp))

returns the last day (date) of the month that contains SomeDateOrTimestamp.

Another expression that additionally formats the result as date would be:

DayName(Monthend(SomeDateOrTimestamp))

hope this helps

regards

Marco

taylor_jesse — Thu, 12 Jul 2018 20:53:07 GMT

Thank you