how to get 1st april date from today function

[kunkumnaveen]

Hello,

how to get 4/1/2017(MM/DD/YYYY)date format   using today() function when a fiscal year 2018 is selected

Thanks

[Chanty4u]

Try this

=date(Today(),'MM/DD/YYYY')

[prma7799 · Accepted solution]

Try like this

=YearStart(Today(),0,4)

Or

=date(Today(),'MM/DD/YYYY')