Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
how to get 4/1/2017(MM/DD/YYYY)date format using today() function when a fiscal year 2018 is selected
Thanks
Try this
=date(Today(),'MM/DD/YYYY')
Try like this
=YearStart(Today(),0,4)
Or
=date(Today(),'MM/DD/YYYY')