Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Use AddYears(today()-1,-1) for Previous Year
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
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...
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
Hi
Try below
=MonthStart(AddYears(today()-1,-1))
or
=MonthStart(Today())
but I want same for calendar previous year and before previous year then =MonthStart(Today()) condition fails
what date you are getting now....?
This thread is already resolved, right?