Note that the _add_days, _add_years functions in query calculations take a date expression as an input while the same in a layout calculation takes a timestamp as an input. Hence while using layout calculations you need to convert the date to timestamp as shown below:
_add_years(date2timestamp(Today()),-1)
Awesome! You just saved me two hours of work. Thanks!
ReplyDeleteGreat to know that this blog is serving its purpose. Thank you all for your kind words.
ReplyDeleteI second that - thanks!
ReplyDelete