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
Ivana Gasparekova
12/18/2023, 7:23 PM
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
Alex Gertman
12/18/2023, 7:27 PM
great, thanks Ivana!
🤞 1
i
Ivana Gasparekova
12/18/2023, 7:29 PM
(And sorry for not posting my original post under the right thread, my bad. 😉 )