AwsTimestamp ( TrueForDateOnly )

ISO-8601 UTC GMT timestamp (for use in AWS transactions)

Average rating: 5.0 (1 vote) Log in to vote

Dave Moyer - Show more from this author

Sample input:

AwsTimestamp(False)
AwsTimestamp(True)

Sample output:

20211219T160416Z
20211219

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

/* returns a GMT timestamp (ISO-8601 for use in AWS transactions)   */
/* returns yyyymmddThhmmssZ if parameter is boolean False           */
/* returns only yyyymmdd if parameter is boolean True               */

Let(
  [
    ~utcSeconds = Int(Get(CurrentTimeUTCMilliseconds) / 1000);
    ~timestamp = GetAsTimestamp(~utcSeconds);
    ~date = GetAsDate(~timestamp);
    ~time = GetAsTime(~timestamp);
    ~year = Year(~date);
    ~month = Month(~date);
    ~day = Day(~date);
    ~hour = Hour(~time);
    ~minute = Minute(~time);
    ~second = Seconds(~time)
  ];
  ~year & 
  Right("0" & ~month; 2) & 
  Right("0" & ~day; 2) & 
  If(GetAsBoolean(TrueForDateOnly);
    "";
    "T" & 
      Right("0" & ~hour; 2) & 
      Right("0" & ~minute; 2) & 
      Right("0" & ~second; 2) & 
      "Z"
  )
)

// by Dave Moyer

I wrote this for use in REST transactions between FM and AWS S3.
It provides the GMT timestamp required in the authentication processes.
When only the date is required, provide a boolean True as the function parameter.

Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

AwsTimestamp ( TrueForDateOnly )

Comments

Support this website.

Support this website.