Set default DATE or time period ?????

[#1]

How i can set default Current Date or Time Period in my report/Dashboard ???????

[martin59]

Hello,

You have to use =today() or =now() functions in a text area.

[#3]

Thanks Martin , but i want it when i have to set for a default month ??????

Is there any possibility that report automatically starts up at default month ????/

Regards

Ashwin

[#4]

Dear All ,

Is there any option for getting default month on the report / dashboard..............???

I have tried but not getting it. i want to restrict my application to current month.

Regards

Ashwin

[martin59]

Have you tried =Month(Today()) ?

[johnw]

So you want to actually select the current month automatically? I've done this with macros that execute when you open the document. For example, this selects a bunch of fields and activates a particular sheet. It sets the month to the previous month. The current month wouldn't need the addmonths(...,-1). You might be able to do this with actions in 9.0. I haven't really used actions yet since we're officially on 8.5 still.

sub initialSelections()
ActiveDocument.GetField("Date Type").Select "Activity Date"
ActiveDocument.GetField("Month").Select ActiveDocument.Evaluate("date(addmonths(monthstart(today(1)),-1),'MMM YY')")
ActiveDocument.GetField("Location").Select "PCM"
ActiveDocument.GetField("Show Weights In").Select "Tons"
ActiveDocument.GetField("Show Coating In").Select "oz/ft2"
ActiveDocument.GetSheet("Yields by Product").Activate
end sub