Changing date format

[mushroom]

Hi,

Can anyone help?

I'm using the script below and after adding to the DB it has altered the date format ( payment date) to US MM/DD/ YY style.

Case (
IsEmpty ( PaymentMethod ) ; " Invoice Status" ; TextStyleAdd ( PaymentStatus & " " & payment date ; Bold)  & ¶  & TextSize ( PaymentMethod ; 10 ) ; PaymentStatus  & "  "  & payment date  & ¶  & TextSize ( " "  & PaymentMethod; 12 )      )

How can I get this back to UK DD/MM/YY?

I've tried using the Inspector and my original date fields used elsewhere on the layout are unchanged. I've put it on the layout as <<payment info popover>>  (borrowed from the Starter solution- Invoice) 

Thanks

Tony

[GisMo]

Did you try the Custom Data Formatting option in the Data Tab in the Inspector?

 

[comment]

1 hour ago, mushroom said:

it has altered the date format ( payment date) to US MM/DD/ YY style.

What do you mean by "altered"? When was it different? To me, it sounds like your file is set to use the MM/DD/YYYY format. If your system is using a different format, set the file to 'Always use current system settings' (under File > File Options… > Text). Or - preferably - clone the file and import your data into the clone.

[mushroom]

HI Gizmo and Comment,

Thanks to  both of you.

Tried those already...

The system is set to DD/MM/YY. Just odd that when only used in the script, the 'payment date' field has reverted to US style. I copied the script from Starter solution which was also DD/MM/YY format. Would it have corrupted 'en route' as the Starter solution was probably created in US style? All other date files are fine.

Much head scratching....

BTW am using FM14

[comment]

Some things are missing from your description:

1. What do you have selected under File > File Options… > Text?
2. You keep talking about a script, but you show us a calculation field (at least that's what it looks like).

Another thing to check:

• Enter Layout mode;
• Select the text block where you field is merged;
• In inspector > Data > Data formatting, select Format: [ As entered ]

 

 

[mushroom]

Hi Comment,

Ok it's a calculation.

This is it from the Starter solution which I borrowed showing UK date in the screenshot below.

Case    (
    IsEmpty ( Method ) ; "Set Payment Status" ;
    $$PLATFORM = "Desktop" ; TextStyleAdd ( Status & "    " & Date Payment ; Bold )  & ¶ & TextSize ( Method ; 12 ) ;
    Status & "    " & Date Payment & ¶ & TextSize ( "    " & Method ; 16 )
    )

My version is:

Case (
IsEmpty ( PaymentMethod ) ; " Invoice Status" ; TextStyleAdd ( PaymentStatus & " " & payment date ; Bold)  & ¶  & TextSize ( PaymentMethod ; 10 ) ; PaymentStatus  & "  "  & payment date  & ¶  & TextSize ( " "  & PaymentMethod; 12 )      )

It's the 'payment date' field that's reverted/ changed. Starter calls it 'Date Payment'

I attach screenshots from Starter and File options for help .

Appreciate your time.