Date / Time Issue

By David Gyenes, Director of Information Technology

It looks like using an ISO (YYYY-MM-DDTHH:MM:SSZ) format to pass Date / Time information between our local computer and server is working well for me so far. How can you create this? Well we know the format() function. It can be used for Date, Time or Date / Time fields. Example: Date is a Date type field.

					format(Date, “YYYY-MM-DDThh:mm:ssZ”)				

In the next example I use a Date and a separate time field and I add my current time zone at the end. When the server processes this it still comes out correctly instead of being off because of the time zone difference.

					format(Date, “YYYY-MM-DDT”) + format(Time, “hh:mm:ss”) + format(today(), “Z”);				

I store this in a variable before I use the “do as server” function then give the value of the variable to the Date / Time field I’m trying to update.