Announcements
cancel
Showing results for
Did you mean:
Partner - Contributor III

## Min Date for creating master Calendar

Hi Experts,

I have to create master calendar with default dates because I don't have the date field.

My Min date will be = 01/03/2018  (DD/MM/YYYY)

and

My max date will be = Today()-1

Please guide how can I achieve this.

Labels (3)

• ### set min date for master calendar

1 Solution

Accepted Solutions
MVP

Try like:

Let vMinDate=Num(MakeDate(2018,3,1));
Let vMaxDate= Num(Today()-1);

Date(\$(vMinDate)+RowNo()-1) as Date,
Month(\$(vMinDate)+RowNo()-1) as Month,
Year(\$(vMinDate)+RowNo()-1) as Year
AutoGenerate \$(vMaxDate)-\$(vMinDate)+1;

Edit: corrected the min date

4 Replies
MVP

Try like:

Let vMinDate=Num(MakeDate(2018,3,1));
Let vMaxDate= Num(Today()-1);

Date(\$(vMinDate)+RowNo()-1) as Date,
Month(\$(vMinDate)+RowNo()-1) as Month,
Year(\$(vMinDate)+RowNo()-1) as Year
AutoGenerate \$(vMaxDate)-\$(vMinDate)+1;

Edit: corrected the min date

Partner - Master

Hi Deepaksingh,

Use the following.  @MK_QSL  had solved this before. I've edited a bit for you.

`MinMaxDate:LoadFloor(Date('08/12/2005','DD/MM/YYYY')) as MinDate,Floor(Today()-1) as MaxDateAutoGenerate 1;Let vMinDate = NUM(PEEK('MinDate',0,'MinMaxDate'));Let vMaxDate = NUM(PEEK('MaxDate',0,'MinMaxDate'));Calendar:Load  Date(DateNum) as Date,  Month(DateNum) as Month,  Year(DateNum) as Year;  Year(DateNum) as Year;Load  \$(vMinDate) + IterNo() - 1 as DateNumAutoGenerate 1While \$(vMinDate) + IterNo() - 1 <= \$(vMaxDate);`

Jordy

Climber

Work smarter, not harder
Partner - Contributor III
Hi
You can use this formula =makedate(2019,01,01) for Min date.
You can use this formula =date(today()-1,"DD/MM/YYYY") for Max Date

Regards
Frank
Partner - Contributor III
Author

Thank you all for your immediate response and suggestions.