Date format on Web services

Post any questions you have about using the Verj.io Studio, including client and server-side programming with Javascript or FPL, and integration with databases, web services etc.

Moderators: Jon, Steve, Ian, Dave

rupenmody
Ebase User
Posts: 5
Joined: Tue Nov 06, 2007 1:08 pm

Date format on Web services

#1

Postby rupenmody » Thu Nov 08, 2007 11:34 am

Hi,

When we have dates as part of a webservice resource, it outputs it in the following format as part of the request

<proc>2002-05-04Z</proc>

but the webservice that we are trying to connect to, is failing it, as it expects the date in a different format.

Is it possible to change the format in which is date is sent as part of the request?

Thanks

Rupen
0 x

Steve
Moderator
Moderator
Posts: 414
Joined: Fri Sep 07, 2007 3:44 pm
Location: Sandy, UK
Contact:

#2

Postby Steve » Thu Nov 08, 2007 4:18 pm

Hi Rupen,

The only way you can achieve this is by setting the proc field as a String and using the formatdate(date1,string2) function in Ebase to convert a date representation of the field.

e.g

set PROC = formatdate(PROC_DATE, 'dd/MM/YYYY');

and changing the PROC field display type to character.

Hope this helps.

Steve
0 x

rupenmody
Ebase User
Posts: 5
Joined: Tue Nov 06, 2007 1:08 pm

#3

Postby rupenmody » Thu Nov 08, 2007 5:52 pm

Yep, thanks it makes sense.

Cheers

Rupen
0 x


Who is online

Users browsing this forum: No registered users and 13 guests