topic using filed in place of variables in App Development

using filed in place of variables

swiftfahad — Tue, 03 Jan 2023 05:37:58 GMT

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 — Tue, 03 Jan 2023 05:45:56 GMT

@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 — Thu, 13 Jul 2023 08:32:35 GMT

it works thanks