Date(Date#()

[taylor_jesse]

Hi

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 · Accepted solution]

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]

Thank you