calender dates

[Anonymous]

Hi

I want when i open the dashboard by default dates should be selected as follows:-

For current year

1st day of current month and current year - one day before system date ie 1st april 2018 till 23rd april 2018

for previous year

1st day of current  month and previous year - one day before system date ie 1st april 2017 till 23rd april 2017

How to implement same?

[YoussefBelloum]

hi,

do you want to see the dates desribed above here ?

what are the variables used and what are their expressions?

[Anonymous]

yes I want same dates to be shown in calender

but i want this should be done using triggers

variables used area as follows:-

vstart for previous year starting date

vend for previous ear ending date

I have used triggers

vstart

monthstart(vstart)

but i want april 23,2017 to be displayed in calender. How to obtain that?

[YoussefBelloum]

What is the expressions used inside your variables: vstart and vend ?

[Anonymous]

=num(count({ stateA<Sold_Date = {">=$(vstart)<=$(vend)"} >}DISTINCT SAPCode),'#,##0.0')

[Anil_Babu_Samineni]

Can you help us to consider as Field in selector and see that trigger working or not instead of Calendar?

[Anonymous]

if in trigger I am using monthstart(vstart)-1 its not giving correct answer in text box

[Anil_Babu_Samineni]

What value you are getting in text box when you use =vstart? Or =$(vstart)

[Anonymous]

vstart variable is functioning fine. I want vend variable to display 23rd april 2016

[Anil_Babu_Samineni]

Will you able to share sample?