Is there any specific format for date time values?
We define this spreadsheet:
Spreadsheet SpreadsheetResult calc(Date f)
s = hour(f)
How is the correct date time format to show the hour? We tried this formats
without any luck: YYYY-MM-DD HH:MM / YYYY-MM-DD HH:MM:SS / YYYY-MM-DDTHH:MM
Hello, unfortunately, the date can't be entered wia Webstudio Date UI controls, but there are other ways to enter it.
1) via Json {
"f": "2022-01-21T17:51:01.480Z"
}
2) Since OpenL 5.25.2 the date with time can be defined from the test/data tables. See the calcTest in the file attached
Hi:
Is there any specific format for date time values?
We define this spreadsheet:
Spreadsheet SpreadsheetResult calc(Date f)
s = hour(f)
How is the correct date time format to show the hour? We tried this formats
without any luck: YYYY-MM-DD HH:MM / YYYY-MM-DD HH:MM:SS / YYYY-MM-DDTHH:MM
Hello, unfortunately, the date can't be entered wia Webstudio Date UI controls, but there are other ways to enter it.
1) via Json {
"f": "2022-01-21T17:51:01.480Z"
}
2) Since OpenL 5.25.2 the date with time can be defined from the test/data tables. See the calcTest in the file attached
Best Regards,
Alena.