JSON date and time

Save money by purchasing our NeoPlugins bundles. Five, Ten and even the complete NeoPlugins collection at an incredible price!

DecSoft NeoPlugins are available in both runtime and designtime flavours to keep your apps as small as possible.

Apache Cordova's official plugins are supported out of the box and there are hundreds of plugins ready to use.

Compile, convert your modern HTML apps and games into Microsoft Windows executable programs without dependencies.

Create apps and expand their capabilities by using the world's popular programming language: Javascript.

DecSoft NeoPlugins put your VisualNeo projects into another level with +1,000 new actions for your apps.

Create multiplatform apps with DecSoft App Builder, including Android and iOS with the same base of code.

Take a look at our YouTube channel and subscribe to be notified about new videos!

DecSoft HTML Compiler include a convenient Command Line Compiler, so you can compile your apps from the console.

DecSoft HTML Compiler is easy to use: set your project's options and compile your apps and games in a nutshell.

Design for small screen devices but deploy also (without changes) in larger devices like tablets.

DecSoft App Builder integrates an Open AI assistant in order to assist you while developing your apps.

Create modern HTML apps and games at another level making things impossible to do even by modern HTML apps and games.

DecSoft App Builder include a convenient Command Line Compiler, so you can compile your apps from the console.

Take a look at some frequently asked questions about us and our products!

Save time, resources and money creating apps for Android, iOS and more with the same base of code.

Ryan Sytsma

I get JSON date and time values from an API call.

{"id":"3fa23e81-6a72-4d66-a9f0-fec03c5e0704","crew_name":"PTS01","crew_date":"2019-09-15T00:00:00","crew_start":"2019-09-15T08:00:00","crew_end":"2019-09-15T17:30:00

I need to format the date and times for display. Would this code do what I am trying to do?

ObjectGetProp "[crewArrayRow]" "crew_name" "[crew_name]"
  ObjectGetProp "[crewArrayRow]" "crew_date" "[crew_date]"
  ObjectGetProp "[crewArrayRow]" "crew_start" "[crew_start]"
  ObjectGetProp "[crewArrayRow]" "crew_end" "[crew_end]"
  DateFormat "[crew_date}" "MM" "[crewDateMonth]"
  DateFormat "[crew_date]" "DD" "[crewDateDay"
  DateFormat "[crew_date]" "YYYY" "[crewDateYear]"
  SetVar "[formattedCrewDate]" "[crewDateMonth]/[crewDateDay]/[crewDateYear]" "String"
...do the same with crew start and crew end
...create a new array to push to control

DecSoft

Hello Ryan,

A couple of things. To format a date we must create a date variable first, so the way is the below one:


// Create a date from the received date
NewDate "2019-09-15T00:00:00" "YYYY-MM-DD" "[MyDate]"

// Once we have a date variable, we can format it to be show
DateFormat "[MyDate]" "YYYY-MM-DD" "[FormattedDate]"

The other thing is related with the "ObjectGetProp" action. It's no problem to use it, but, for your knowledge, it's also possible to directly access the object properties from the server's response, so, it's possible to write something like the below one:


// Create a date from the received date
NewDate "[MyHttpClient.Response.myDate]" "YYYY-MM-DD" "[MyDate]"

// Once we have a date variable, we can format it to be show
DateFormat "[MyDate]" "YYYY-MM-DD" "[FormattedDate]"

Purchase one or more licenses of our products if they are useful to you!

Ryan Sytsma

I followed the pattern you pointed out here:

NewDate "[crew_date]" "MM-DD-YYYY" "[newCrewDate]"
  DateFormat "[newCrewDate]" "MM-DD-YYYY" "[formattedCrewDate]"
  Alert "test" "[formattedCrewDate]"

  NewDate "[crew_start]" "HH:MM A" "[newCrewStart]"
  DateFormat "[newCrewStart]" "HH:MM A" "[formattedCrewStart]"
  Alert "i" "[formattedCrewStart]"

  NewDate "[crew_end]" "HH:MM A" "[newCrewEnd]"
  DateFormat "[newCrewEnd]" "HH:MM A" "[formattedCrewEnd]"
  Alert "i" "[formattedCrewEnd]"

All I get in the Alert is "Invalid Date". If I declare NewDate with a value and format, why do I need to call DateFormat?

Can the date formats be MM/DD/YYYY?

DecSoft

Hello Ryan,

With "NewDate" you create a new date variable, and, since you do it using a value, you specify the format of that value, in order to properly create the date. Once you have a date variable, and, if you want to show it, then you can use the "DateFormat" action.

I think the problem here can be the time format, that is, probably we can't create a date variable only with time information / format. So, if we can't create the date variable correctly, we can't format that non valid date variable.

Purchase one or more licenses of our products if they are useful to you!

Ryan Sytsma

Are there any suggestions of how to handle this issue? Maybe JS would handle it better? Could I format the time values as a date and time like MM/DD/YYYY HH:MM A and then use DateGet to build a string representing the time?

DecSoft

Hello Ryan,

I think we are missing something here, because, in fact there is no issues, that is, take a look at the below code:


// Create a date from the received date
NewDate "2019-09-15T21:22:23" "YYYY-MM-DDTHH-mm-ss" "[MyDate]"

// Once we have a date variable, we can format it to be show
DateFormat "[MyDate]" "YYYY-MM-DD HH:mm:ss" "[FormattedDate]"

This time we take in consideration both date and time, so, what "[FormattedDate]" stores is "2019-09-15 21:22:23". In other words, it's perfectly possible to create a date variable which include the date and the time.

Maybe I confuse you because I mention above that we can't create a date variable only with the time... and this is truth, that is, only with the time we can't create a date variable, but, we can create date variables (as you can see below) that stores both date and times values.

Once we have a date variable, we can use several available actions to extract the days, month, etc. Or just to show the date variable in certain format, like the code above does.

Purchase one or more licenses of our products if they are useful to you!

Ryan Sytsma

David, thanks for your help. I went ahead and formatted the date and time on the C# server side code in the API. It returns in proper format in the GET response now.

DecSoft

Hello Ryan,

It's another way, of course, but, please, don't use the server... if you want to use the client... as you can see above, it's possible to create a date variable from an arbitrary value, and, then it's also possible to show that date variable in certain specific format. It's possible, so, if you find any trouble... just post it here and we will see...

Purchase one or more licenses of our products if they are useful to you!

Everybody can read the DecSoft support forum for learning purposes, however only DecSoft customers can post new threads. Purchase one or more licenses of some DecSoft products in order to give this and other benefits.