0
How to display a long format date in print out?
I'm creating a quotation database. I want to display the date field so it reads '1st February 2019' rather than '1 Feb 2019' as is the default. How do I do this?
3 replies
-
Hello. Try this:
format(Date, "D MMM YYYY")Fabio
-
Great! That worked except I put in
format(Date, “D MMMMMMMM YYYY”)
to get the full month name to display.
Thanks!
-
Amendment: the above was showing the month twice - just MMMM showed up as ‘February’ rather than ‘Feb’
Content aside
- 5 yrs agoLast active
- 3Replies
- 1262Views