I need to be able to create a filemaker calculation field that converts a given date into unix format. I have the formula for excel:

[(DATE(Year,Month,Day)+TIME(Hour,Minute,Second)-25569)*(86400)]

but converting the date to a numerical format in excel is not equaling the number that filemaker gives me. Help!

I need to be able to create a filemaker calculation field that converts a given date into unix format. I have the formula for excel:

[(DATE(Year,Month,Day)+TIME(Hour,Minute,Second)-25569)*(86400)]

but converting the date to a numerical format in excel is not equaling the number that filemaker gives me. Help!

I need to be able to create a filemaker calculation field that converts a given date into unix format. I have the formula for excel:

[(DATE(Year,Month,Day)+TIME(Hour,Minute,Second)-25569)*(86400)]

but converting the date to a numerical format in excel is not equaling the number that filemaker gives me. Help!

Try for the date part:

((Date Entry - Date(1,1,1970)) * 86400)

I've never used this, I only collected it from some post.

HTH

Lee

Try for the date part:

((Date Entry - Date(1,1,1970)) * 86400)

I've never used this, I only collected it from some post.

HTH

Lee

Try for the date part:

((Date Entry - Date(1,1,1970)) * 86400)

I've never used this, I only collected it from some post.

HTH

Lee

Yes, that helped tremendously because it works! Thank you!

Yes, that helped tremendously because it works! Thank you!

Yes, that helped tremendously because it works! Thank you!

Oh, you mean Unix time. Try this:

Let ( [

UnixEpoch = Timestamp ( Date ( 1 ; 1 ; 1970 ) ; Time (0 ; 0 ; 0 ) ) ;

Offset = Time ( GMT ; 0 ; 0 ) ;

Now = Timestamp ( theDate ; theTime - Offset )

] ;

GetAsNumber ( Now - UnixEpoch )

)

/*

GMT = the difference, in hours, between your local time and GMT

Example:

for EASTERN STANDARD TIME enter -5;

for EASTERN DAYLIGHT SAVING TIME enter -4.

*/

Oh, you mean Unix time. Try this:

Let ( [

UnixEpoch = Timestamp ( Date ( 1 ; 1 ; 1970 ) ; Time (0 ; 0 ; 0 ) ) ;

Offset = Time ( GMT ; 0 ; 0 ) ;

Now = Timestamp ( theDate ; theTime - Offset )

] ;

GetAsNumber ( Now - UnixEpoch )

)

/*

GMT = the difference, in hours, between your local time and GMT

Example:

for EASTERN STANDARD TIME enter -5;

for EASTERN DAYLIGHT SAVING TIME enter -4.

*/

Oh, you mean Unix time. Try this:

Let ( [

UnixEpoch = Timestamp ( Date ( 1 ; 1 ; 1970 ) ; Time (0 ; 0 ; 0 ) ) ;

Offset = Time ( GMT ; 0 ; 0 ) ;

Now = Timestamp ( theDate ; theTime - Offset )

] ;

GetAsNumber ( Now - UnixEpoch )

)

/*

GMT = the difference, in hours, between your local time and GMT

Example:

for EASTERN STANDARD TIME enter -5;

for EASTERN DAYLIGHT SAVING TIME enter -4.

*/