Date string?

[Richard Torrens (lists)]

Is there a function that turns a date into a text string?

I am trying to make an html table and need to output a cell e.g.

join("<td class=""red"">",weekstart,"</td>")

where weekstart is a date, so the join function gives an error.


There are plenty of functions to turm strings into dates, but I can't find
the reverse

--
Richard Torrens.
http:/diy.Torrens.org/RO for PipeDream hints & tips

[Stuart Swales]

On 16/07/2020 15:01, Richard Torrens (lists) wrote:
> Is there a function that turns a date into a text string?
>
> I am trying to make an html table and need to output a cell e.g.
>
> join("<td class=""red"">",weekstart,"</td>")
>
> where weekstart is a date, so the join function gives an error.
>
>
> There are plenty of functions to turm strings into dates, but I can't find
> the reverse
>

How about TEXT("<date format>",date)?

--
Stuart Swales

[Richard Torrens (lists)]

In article <92896774-9fb1-4125...@gmail.com>,

Stuart Swales <stuart.swale...@gmail.com> wrote:
> On 16/07/2020 15:01, Richard Torrens (lists) wrote:
> > Is there a function that turns a date into a text string?
> >

[Snip]

> How about TEXT("<date format>",date)?

Hadn't looked in the addendum! But
http://croftnuisk.co.uk/coltsoft/pipedream/addenda_and_errata/
says TEXT(number, string)
number may be a number or a date.
string is a format string in Fireworkz number format style.

So I look at
https://croftnuisk.co.uk/coltsoft-docs/fireworkz/UserGuide/content/sg03/sg3_number_formats.htm

which doesn't help solve the string for <date-format>. Then I find out
that the links at the bottom
Prev Up Next
all point at themselves so go nowhere!

I have solved this question another way - see my private email

[Stuart Swales]

Somewhat embarrassingly, all the Prev/Up/Next links in Chapter 3 of the Spreadsheet Guide are blank! Just fixed this here and will upload later - thanks for the report.