francesco.boano

Date formats with PostgreSQL

Discussion created by francesco.boano on Aug 5, 2016
Latest reply on Sep 12, 2016 by user19752

Hi,

I've an external data source Postgre connected via Actual Tech Connector.

Everything seems working fine, apart the dates.

 

Two problem:

1. PostgreSQL timestamptz field are recognized in FileMaker as Text. I can display and change them correctly, but when I try to show the in a Calculated field (e.g.: Month(start_date)) they do not works. I also tried Month(GetAsDate(start_date))) with no luck as well. Any idea ?

2. PostgreSQL date field are seen as date, but when I set them with function Date (1, 1, 2016), I get a question mark shown on the input filed (no size problem) and I got this error:

 

Errore ODBC: [Actual][PostgreSQL]  ERROR:  invalid input syntax for type date: "?"

LINE 1: ...ation"("purchase_orders_id","month_date") VALUES(4,DATE '?')

                                                                   ^

Thanks a lot!

Francesco

 

I'm using FileMaker 15

Actual driver 4.0.0

Postgre 9.5.2

Mac

Outcomes