I tried to eliminate the time from this = Dec 31, 1969 at 4:00 PM
But this doesn’t do it (using the DATE(x,x)
DATE(DATEADD(Orig-Date;0;0;0;Interval-days;0;0;0);”MM-dd-yy”)
How can I get rid of the time?
How about changing the field type to “Date” instead of “Date & Time”?
Make sure you’re using straight quotes instead of curly quotes in the formula for your date pattern. But ya, you could return a Date from the formula instead of coercing it into a string with a date pattern. A Calculation field has full support for using the built-in date formatters or for specifying your own.
The Field Type is a “Calculation”, so I don’t have it set to “Date”
Then all calculation disappeared and I lost my data.
Set it back to “Calculation” and after struggles got my data back.
I took out the DATE(). Still has the time.
Number Format = no style. Tried “years, months, days” – didn’t work.
My calculated field is set to date format = Medium – Feb 7, 2023.
Below that is the time which I have as default. No option for no time.
So, I don’t see where you can format it correctly.
You need to set the Result Type on the Formula Edit screen to Date, not the Field Type. Sorry for the confusion.
The Number Format time styles are just for displaying duration values, not actual dates or times. E.g. 12:05 meaning 12 hours and 5 minutes. Not 12:05 PM or AM.
.
