How to arbitrarily format a date variable

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

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

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

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

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

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

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

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

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

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

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

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

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.

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

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

Peter Bradstreet

Hi David,

I have a scenario where I am taking a note record and putting it into local storage and also calling a rest service at the same time and inserting it into a MySQL database. I want to place an 'Updated' timestamp in both places so that I can compare the records to update the local record based on the remote record if the Updated value is greater in the database than the local version etc...

The problem that I am having is that the format that the Updated timestamp is being saved in local storage is not the same format that I need to submit to the rest service. Here is my insert code:

// Prepare a new record object to be inserted
NewDate "[App.Timestamp]" "" "[Date]"
DateToJSDate "[Date]" "[DateUpdated]"


NewObject "[NewRecord]"
ObjectSetProp "[NewRecord]" "ID" "[App.Timestamp]"
ObjectSetProp "[NewRecord]" "Title" "[TitleInput.Value]"
ObjectSetProp "[NewRecord]" "Note" "[NoteInput.Value]"
ObjectSetProp "[NewRecord]" "Updated" "[DateUpdated]"

// Insert the new record at the begin of the Report Data
ArrayUnshift "[NotesReport.Data]" "[NewRecord]"

// Update the app's local storage using the
// below "UpdateLocalStorage" app's function
UpdateLocalStorage
SetVar "submittoken" "ZG9ja2l0dG9r=" "String"
// Prepare our insert new note HTTP post request
HttpClearData "NewNote"
HttpSetUrl "NewNote" "https://mymarina.online/iPort/REST/dockit/API_NoteCreate"
HttpSetData "NewNote" "Token" "[submittoken]"
HttpSetData "NewNote" "VesselToken" "OxkLCA5fGnVBR0BDAk"
HttpSetData "NewNote" "UserToken" "AxMNBFpSBiEQAAAEVRYCOQYZUR0sWhAbGw"
HttpSetData "NewNote" "Title" "[TitleInput.Value]"
HttpSetData "NewNote" "Note" "[NoteInput.Value]"
HttpSetData "NewNote" "Updated" "[DateUpdated]"


HttpExecute "NewNote"
ReplaceView "Home"

The local storage 'Updated' format is Sun Apr 21 2019 09:00:57 GMT-0500 (Central Daylight Time) but I need to submit it to the server as 2019-04-21 09:00:57:15

This seems like it should be fairly straight forward but I can't seem to figure out the correct syntax to do this. In a perfect world, I would like to store it locally and in MySql in the format: yyyy-MM-dd hh:mm:ss so that I can easily compare them.

Any help would be greatly appreciated!

Pete

decsoft

Hello Peter,

If the server is controlled by us, then we can submit the data in the format that we wanted, and, then format it again in the server if required (for example, to store in a database). You can use timestamps (maybe better for comparisson purposes?) or any date format. However, with the DateFormat action, we can certanly prepare a date string exactly in the format that we wanted, so, for example, the below code format a string just like you use in the server side:


NewDate "[App.Timestamp]" "" "[Date]"

DateFormat "[Date]" "YYYY-MM-DD HH:mm:ss" "[DateStr]"

Alert "" "[DateStr]"

Note that I use a different format string than what you shown: "yyyy-MM-dd hh:mm:ss": this is because the format string that I use follow the DateFormat action documentation, and this is what we must to do, of course.

In other words, if we try with your suggested format string "yyyy-MM-dd hh:mm:ss", we don't get the desired result. For your desired date format, the format string that we must use is "YYYY-MM-DD HH:mm:ss", just like you can see in the above piece of code.

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

Peter Bradstreet

Many thanks! Got it all working. Pete

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.