text object

[smilingjohn]

In a text object iam trying to get the min date for which iam writing the below expression

Min(Date) ...and the output is not in the date format .....it shows someting like41034

[MK_QSL · Accepted solution]

=Date(Min(Date))

Why don’t my dates work?

[stonecold111]

=date(min(date,'MM/DD/YYYY')