I Want Get the File Creation Date, But I Can't Understand the Number of the Result

[som]

Hi,

I want get the file creation date, but I can't understand the number of the result.

Here is the macro and the result:

The file creation date is 01.11.2022, what's the logic of the number:1667242231

Thanks.

[ComplexPoint]

@som

01.11.2022

"01.11.2022" is a string which is legible (in context) but not computable.

The underlying representation (translatable to a variety of formatted strings, for particular regions and time-zones) is a number of seconds since the start of Jan 1 1970 GMT ( variously known as Epoch Time, Unix Time, etc – see Unix time - Wikipedia)

See also:

KM Dates & Times: Notes on Anchors, Intervals, and Translations

Finding that I wasn't very familiar with KM date calculations and date formatting, I sketched some draft notes and examples. (For initial simplicity, I have kept to the Unix Epoch Seconds functions, and left the Julian Day functions aside, though they are clearly indispensable for historians, and convenient for quick counts of days between two dates ) Here are some rough draft notes (now incorporating several edits and fixes suggested by Peter) on: Anchor date-times ( absolute calendar date…

[kcwhat]

@som - Is this what you are looking for?

If so, here is the action:

file date action.kmactions
(499 Bytes)

If not, disregard.
KC

[som]

Thanks – yes this is what I'm looking for.