how to insert a non-standard Field -ie. day before today

N

Nicole L.

Is there a formula/code in order to insert a Field that will automatically
input the Full Month Before the current Date's Month (the date you're working
on the doc)?

Any ideas?

For example, this is for a Monthly Report - I want to be able to put the
field in the Heading/title to be the Monthly Report for the Month PRIOR to
when I'm filling the report out.
 
T

Tony Jollans

I suspect it should be simpler - these manipulations are awkward - but ...

{ Quote { ={ ={ If { date \@ "MM" } = 1 12 { ={ date \@ "MM" } - 1 } } * 100
+ { date \@ "yyyy" } * 10000 + 1 } \# "0000/00/00" } \@ "MMMM yyyy" }
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top