Date display in email

[shoily]

I know how to change the way a date displays in FileMaker -- 4/17/2010 and April 17, 2010. That's NOT my question. I want to send a email from FM with date displayed as April 17, 2010 so that international customers can easily understand it.

[LaRetta]

One option is to use a a SQL date because it is understood by everyone and it is considered the standard universally:

// SQL date YYYY-MM-DD

Let ( [

y = Year ( date ) ;

m = SerialIncrement ( "00" ; Month ( date ) ) ;

d = SerialIncrement ( "00" ; Day ( date ) )

] ;

y & "-" & m & "-" & d

)

... and no matter the OS settings, FM can (I believe) properly interpret and translate the dates appropriately since we are using Date() functions.

[IdealData]

Make a calculation field and use that in your email:

Month (date) & " " & Day (date) & ", " & Year (date)

[LaRetta]

I see what you're getting at, Mark. Thanks for the catch! I was assuming that the standard date is misinterpreted (3/1/2010 and 1/3/2010).

I think you mean MonthName() there.

[shoily]

I wrote the original question and these responses don't make much sense to me. The dates 3/1/2010 and 1/3/2010 ARE often misunderstood by my international customers. I need to generate an email from within FM using this field: Date of Next Invoice = 8/1/2010. Right now, the field is set up as an "Auto-enter Data."

[LaRetta]

As IdealData suggested, you must create a new calculation (result is text):

To get April 19, 2010:

Let ( [

dte = DateOfNextInvoice ;

y = Year ( dte ) ;

m = MonthName ( dte) ;

d = Day ( dte )

] ;

m & " " & d & ", " & y

)

To get 2010-04-19:

Let ( [

dte = DateOfNextInvoice ;

y = Year ( dte ) ;

m = SerialIncrement ( "00" ; Month ( dte ) ) ;

d = SerialIncrement ( "00" ; Day ( dte) )

] ;

y & "-" & m & "-" & d

)

Edited April 19, 2010 by Guest
Changed to different field name

[shoily]

By George I think she's got it!

~ My Fair Lady (1965 movie)

Thanks ever so much.