Hi, is there a MAQL to return the oldest date avai...
# gooddata-cn
a
Hi, is there a MAQL to return the oldest date available? For example, suppose in my data warehouse I've got these dates: Position Date 1/1/2023 2/1/2023 3/1/2023 4/1/2023 5/1/2023 6/1/2023 Is there a MAQL that would return the oldest date is 1/1/2023 ?
i
Hey again Alex, You can certainly work with MAX and MIN functions. Just be aware, it is recommended to build your metric with USING clause, when it comes to date attributes.
a
great, thanks Ivana!
🤞 1
i
(And sorry for not posting my original post under the right thread, my bad. 😉 )