You can kind of do this using a row level formula (can be created in lightning report from dropdown next to 'columns' text).
Year column can be created like so (formula output type = text):
TEXT(YEAR(--date field goes here --))
But you only get one row level formula for each report, so you wouldn't be able to do it for year, month and day.
You cannot configure the evaluate new to be based upon the date field in the Data Extension. Seems like you have two choices.
You will need to Evaluate All and use the Data Extension entry filters to reference the date in the Data Extension. If that does not work, you could alternatively use the Event entry to create a Date Based Entry
If you're simply trying to get the epoch, you can use the Datetime.getTime() method.
Returns the number of milliseconds since January 1, 1970, 00:00:00 GMT represented by this DateTime object.
Here's an anonymous script to get you started:
Datetime timestamp = Datetime.newInstance(
Date.newInstance(2020, 18, 2),
You can use a Process Builder/Workflow Rule/Trigger to achieve this. Just create a custom Date/Time field, choose the appropriate method you want to use (e.g. Process Builder), define the action to fire when it meets your criteria (e.g. ISCHANGED(StageName) && NOT(IsClosed)), and use an action to set the Date/Time field.
The below seemed to work well except with regards to Daylight Savings Time. I'm hopeful, depending on how your UserTimezoneOffset field is set, that this might not be an issue.
For reference, this thread contains where I got the initial structure of the formula from and good discussion about doing what you're looking for. You'll be parsing through the ...