Format date

[Mahamed_Qlik]

Dear All,

I have the expression like :

=Sum( {<Date = {">= $(vStartDate)<=$(vEndDate)"} FareAmount>}

Where vStartDate and vEndDate  are may date variable in number format.

I want to format those variable with date format like (DD-MM-YYYY)

and that i want to do in set analysis so it should be like

=Sum( {<Date = {">= $(=Date(vStartDate,'DD-MM-YYYY)<=$('=Date(vEndDate, 'DD-MM-YYYY'))"} FareAmount>}

Please advise how to write in correct sysntax.

[petter]

You could either write this - which is the same as you had except for an added (missing) single quote character ' and ending characters for the modifier and set   >}   removing a misplaced single quote before the equal sign:

=Sum( {<Date = {">= $(=Date(vStartDate,'DD-MM-YYYY')<=$(=Date(vEndDate, 'DD-MM-YYYY'))"}>} FareAmount>}

or - if this DD-MM-YYYY format is already default date format then this:

Sum( {<Date = {">= $(=Date(vStartDate)<=$(=Date(vEndDate))"}>} FareAmount>}