I have a Month View Calendar, and am trying to modify the dataset containing the events. The default dataset for Month View is (when copy/pasted): "#NAMES" "startDate","endDate","displayColor","display" "#TYPES" "date","date","str","str" "#ROWS","4" "2018-02-21 08:00:35","2018-02-21 12:00:35","blu…

You need to change the format string that system.date.parse is using to fit the format of your string: system.date.parse('2018-02-20 08:00:28','yyyy-MM-dd HH:mm:ss')

@OscarLucas Where are you running your script from, and what columns in the dataset are you wanting to manipulate?

i am using a named queries @justinedwards.jle SELECT MIN(date_format(fichajes.inicio,‘%Y-%m-%d %k:%i:%s’)) as startDate, MAX(date_format(fichajes.fin,‘%Y-%m-%d %k:%i:%s’))as endDate, “blue” as displayColor, QR as display FROM fichajes WHERE MONTH(fichajes.inicio) = :Mes AND YEAR(fichajes.inic…

It looks like the date times are coming through to the dataset in alignment with the SQL query. What format are you looking for? Example: 2022-September-06 21:09:19 Edit: or am I misunderstanding you question?

Well, my question is basically, what format do I have to put in for it to work? Because it does not work. [image]

Understood. It could be because you are missing the meridian, Try adding %p to you query: SELECT MIN(date_format(fichajes.inicio,‘%c/%e/%y, %k:%i:%s %p)) as startDate, MAX(date_format(fichajes.fin,‘%c/%e/%y, %k:%i:%s %p’))as endDate, “blue” as displayColor, QR as display FROM fichajes WHERE MONTH(f…

Actually, I believe the correct format to be: %c/%e/%y, %k:%i:%s %p

[image] justinedwards.jle: %c/%e/%y, %k:%i:%s %p [image] [image]

When you click okay, nothing happens?

No, just is like this. No errors…

Sorry to hear that. It looks perfect now when compared to mine. Perhaps somebody else will have an idea.

Inductive Automation Forum

Format as Date for Dataset

Ignition

scripting, ignition79

show post in topic

Home
Categories
Guidelines
Terms of Service
Privacy Policy

Powered by Discourse, best viewed with JavaScript enabled