topic Date only year 2019 in App Development

Date only year 2019

alessandro — Thu, 28 Nov 2019 11:22:23 GMT

Hi to all.

I would like to insert in a box a field 'date' and to have only the year 2019 (or to specific date).

I tried to insert it like dimension in this way

= Date (MonthStart (ContractCommenceDate), 'YYYY')>= 2019

but is wrong.

Is there someone that give me some advise.

Thanks to all those who want to intervene

I'm sorry, if I wrong "select location".

ciao

ale

Re: Date only year 2019

Anil_Babu_Samineni — Thu, 28 Nov 2019 12:42:06 GMT

May be?

If(Year(ContractCommenceDate)=2019, ContractCommenceDate)

Only({<ContractCommenceDate={"$(=Year(ContractCommenceDate)=2019)"}>} ContractCommenceDate)

Re: Date only year 2019

alessandro — Thu, 28 Nov 2019 13:16:36 GMT

Hi Anil and thanks for your reply.

Your first solution

(If(Year(ContractCommenceDate)=2019, ContractCommenceDate))

is ok but as resulting I have a list of dates, while I would like to have a kind of switc (0-1) so that I could push only one thing, while now I have to push "selection all". But it's the same, but...And besides, it seems to me that the qvd has become slower.

While your second solution, unfortunatly, go in error.

Anyway, thanks a lot.

ciao

ale

Re: Date only year 2019

Anil_Babu_Samineni — Thu, 28 Nov 2019 14:12:43 GMT

I don't know if I understand correctly, But check

(If(Year(ContractCommenceDate)=2019, 1, 0))