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?

[sudhirpkuwar · Accepted solution]

Use AddYears(today()-1,-1) for Previous Year

[Anonymous]

If I need to show calendar dates for before previous year calendar  ie 2016. I need before previous calendar should show the dates as 1st april 2016 till 25th april 2016

[sudhirpkuwar]

Use AddYears(today()-1,-1) for previous year

AddYear(today()-1,-2) for year 2016

AddYear(today()-1,-3) for year 2016

and so on...

[Anonymous]

Hi

I want to add one thing the starting date should be 1st day of current month

for eg:-

current month is may so i want date as 01-05-2018 in calender

[Anonymous]

Hi

Try below

=MonthStart(AddYears(today()-1,-1))

or

=MonthStart(Today())

[Anonymous]

but I want same for calendar previous year and before previous year then =MonthStart(Today())  condition fails

[Anonymous]

stalwar1‌

[sudhirpkuwar]

what date you are getting now....?

[sunny_talwar]

This thread is already resolved, right?