Date format in Spreadsheet App

[GSL007]

Can somebody please tell me how I can enter a date field or date into the spreadsheet app?

Also I understand I need to change my password for this site in the control panel but I can't find the control panel anywhere? Must be blind.

Gary

[KeithB]

For the control panel, just click on your name in blue after the "Welcome Back" Or the "User CP" at the end of that line

[GSL007]

Thank you, Keith.

[BruceH]

(09-26-2024 07:06 PM)GSL007 Wrote:  Can somebody please tell me how I can enter a date field or date into the spreadsheet app?

I don't believe it can format dates the way PC based spreadsheets do. Instead you just use a float in the format yyyy.mmdd as you do for date functions like DATEADD() or DDAYS().

Type DATEADD() and press Help for some examples.

[Tyann]

Bonjour

Vous pouvez :
1) écrire une fonction qui formate la date sous forme de chaîne par exemple
2) appeler cette fonction depuis une cellule du tableur.

J'ai écrit une fonction qui fait cela si vous voulez ?


Hello

You can:
1) write a function that formats the date as a string for example
2) call this function from a spreadsheet cell.

I've written a function that does this if you like?

[GSL007]

That might be helpful,

Merci