DateDDlongMonthYYYY ( xDate )

Converts a date to DD longMonth YYYY format. i.e. 1 Jan 2006

Average rating: 4.4 (29 votes) Log in to vote

Tony Tanevski - Show more from this author
Hi-Voltage
http://www.hi-voltage.com.au

Sample input:

DateDDlongMonthYYYY(1/1/2006)

Sample output:

1 January 2006

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Day(xdate) & " " & MonthName(xDate) & " " & Year(xdate)

An easy custom function that converts a date value into DD longMonth YYYY format i.e. 1 January 2006.

A useful time saver.

Comments

		GrÃ©goire Garneau Apr 29, 2019
Hello, I am new here and I find your site really interesting, a real alibaba cave! I was wondering if there was a simple way to display the results of this function in French? Thanks in advance ! GrÃ©goire

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.