Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a few actions on opening a document. The first 3 are to select the year, month and day to current day as follows:
=Year(YearStart(today()))
=Month(MonthStart(today()))
=Day(DayStart(today()))
This used to work fine for the past months but for some reason as of April 1st, it stopped selecting the year. If I change the order to select the month first and year second, then the month doesn't get selected. It seems the first action stopped working. Is it a known bug or is there a better way to do this date selection to automatically select today's date when the document is opened?
Thanks,
Amit
May be try this
=Year(today())
=Month(today())
=Day(today())
Didn't help - the year was not selected.
I should precise that on the client it does the selection but on the access point when I open the dashboard this is where the issue occurs.
Is it possible to share the .qvw??
Unfortunately I can't it does contain sensitive company data that I am not allowed to share to the public... sorry
Might not be a perfect solution but can you delete the actions and recreate them once?? It happened to me once. I was unaware of the reason but the buttons worked normally later on.
Hi,
= Year(Today())
= Month(AddMonths(Date(today()),0))
= DAY(AddMonths(Date(today()),0))
did you try today(1) or today(2) ?