I’m trying Dto change field (Date and Time) input to Julian day plus time to make a number with a decimal.
I was once told:
=======================
Try using:
DAYOFYEAR([Date Collected])
This function directly returns the Julian day (1–365) without crashing TF5.
========================
See attached, I’ve tried both text and number result.
Attachments:
You must be
logged in to view attached files.
Remove the square brackets [ ] from your formula.
That didn’t work. I tried the formula on both col 1 (full date and time) and DMY with both text and number conditions. See attached.
Attachments:
You must be
logged in to view attached files.
.
