Am trying to make a calendar in Anaplan to plot weekdays and holidays.
Time dimension for the model is "DAY" and I wanted not to type the dates in each days, but to put a formula instead. What would be the formula to return the "date" of the time dimension to the line item. I tried to use "ITEM(TIME)" but it does not return the date but has an error instead.
Sample: If the calendar date in the dimension is Jan 1, 2019, the line item would return 1/1/2019
I attached a screenshot of the calendar module I am working on.
I understood, its very painful to do manual entry.
But it is really simple to bring the date in the line item. All you need to do is , make use of DATE function. If you try to write ITEM(TIME) it will work only if the format is time period. But here we are using DATE as a format, so please have a look at below screen shot for refrence.
I agree with @joshuastockwell but at last it should be 2 instead 1 because we do have 2 digits days uptil 31.
I hope this really helps and solve your problem :).