Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 )
@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 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.
it works thanks