With the B.C. time

[petercreateParticipant]

I have a series of date before Anno Domini. Can I input -5:00:00 if I meant 5 BC?

 

[dgteamModerator]

A zero in UNIX time is January 1st, 1970, so that will not work.

Instead, try a custom date format using an ICU format.  Then you can enter a BC date directly using the format string ‘G’ to represent the era (AD or BC).

If you want to see the equivalent time in seconds use a function column, but for plotting use the Date column so you get the time line correct in the graph.

Here is an example:

See the ICU Users guide for all the formatting options.

Does this work for your case?

 

• This reply was modified 4 years, 3 months ago by dgteam. Reason: Clarified the text

[petercreateParticipant]

Thanks.

[Author]

Posts