using filed in place of variables

[swiftfahad]

I have a expression for text box

Expressions:

Sum( {$<Startdat ={"$(vLastMonth)"}>} Amount )    i.e. Startdat is date filed in database.

Variable:

 vLastMonth =  Date(Max(dat))                                            i.e   my dat field have dates from database.

now can I generate the same output putting directly  max(dat)  insted of variable?

Sum( {$<Startdat ={"Date(Max(dat))"}>} Amount )

[sidhiq91 · Accepted solution]

@swiftfahad Yes, you can generate. Below see the below expression for the same:

=Sum( {$<Startdat ={"$(=Date(Max(dat),'MM/DD/YYYY'))"}>} Amount )

If this resolves your issue, please like and accept it as a solution.

[swiftfahad]

it works thanks