unix date calculation

[GoAng]

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!

[GoAng]

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!

[GoAng]

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!

[Lee Smith]

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

[Lee Smith]

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

[Lee Smith]

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

[GoAng]

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

[GoAng]

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

[GoAng]

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

[comment]

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.

*/

[comment]

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.

*/

[comment]

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.

*/