Login Page - Create Account

Support Board


Date/Time: Wed, 27 Nov 2024 16:35:11 +0000



Post From: Display Date and Day of the week on the Chart

[2023-07-29 16:33:55]
j4ytr4der_ - Posts: 938
OK I just tried this real quick, and the answer is no it doesn't work at all. And it's quite obvious how it couldn't work.

1. Studies can only format numbers in mathematical-type numeric forms. So while it supports Time, it does not support Date. Therefore you can't format anything as date in a Spreadsheet Formula study.
2. Exposing the date in a Spreadsheet System doesn't help, because while you can expose the date number and bring it into a Text Display study, you will just get a number, as formatting it as date in the spreadsheet has nothing to do with the data that is actually puled in by the Text Display study, which is simply the number of the date.

So you can get the date as a number, but not as a date. Someone would need to make a custom study to do this (which would probably be extremely simple for someone with the ACSIL skills... I might be able to figure it out but this isn't important enough to me to devote the time to it).