Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a App, where From Date and To Date has been handled through Calendar Selection and Variable.
Both From and To sourcing same field (Ship Date).
However I want to set the default selection. When User will open it will open for Max(Ship Date).
This default selection is not working for me.
I have applied Trigger.
Can anyone please suggest me.
Thanks,
Sarif
Hi can you try this below on sheet properties and see if this is as you needed?
Thanks
Regards,
Ong Yonathan
hello
may be because the date formats seems not be equal
look at varMaxDate : the leading zero is missing . correct the format
and in your trigger, don't put = sign before the name of the field