Calender Default date today's date and forward 6months

[Anonymous]

Hi,

I have start date which is having dates from 2016 to 2020 so user wants start date dy default is today( Nov17,2020)it's calender approach and end date is by default 6 months i.e (Apr17,2020). How to achieve this?

What i did was have taken disconnected date table and used below code and joined to main table (Start date=Date) but iam not sure how to get by default today's date in start date and 6 months in end date. User shoould be able to select freely like how we are selecting in calender. Kindly suggest.

Calendar =

var _cal = CALENDAR(Min(Start Date]),Max(Start Date]))

RETURN

ADDCOLUMNS (

_cal,

"Year", YEAR([Date]),

"MonthNumber", MONTH([Date]),

"Month",FORMAT([Date],"mmm"),

"Month Year",FORMAT([Date],"mmm yyyy"),

"Month Year Number",FORMAT([Date],"yyyy mm"),

"MonYear",FORMAT([Date],"mmyyyy")

)

Regards,

Venkat

[Anonymous]

@mahoneypat 

Hi, So with your calculation i have used it in slider and showing as expected. Let me explain to client if he satisfies i will come back. Thank you. Please let me know if any changes.

 @amitchandak 

Thanks for your time and sugestion. I will come back

Thanks,

Venkat

[amitchandak · Accepted solution]

@Anonymous , As of now you have to create a flag like this and set yes as default value

Default Date = if([Date] >= today() && [Date] <=date(year(today() ),month(today() ), day(today() )), "Yes", "No")

[mahoneypat]

You can replace your variable with this expression to get that.

var _cal = CALENDAR(TODAY(),EDATE(TODAY(), 6))

Regards,

Pat