How to Change date in mon dd yyyy hh:mm PM to GMT format
Hi,
I have to convert the datetime 'Apr 24 2018 1:50PM' to '20180424T142935.982 GMT ' which I'm getting in clipboard page and need to convert in gmt format
Thanks,
SorenTara
Cognizant Technology Solutions
IN
Hi,
I have to convert the datetime 'Apr 24 2018 1:50PM' to '20180424T142935.982 GMT ' or time "2018-04-24- Proprietary information hidden570" which I'm getting in clipboard to '20180424T142935.982 GMT ' format .
Getting below error while mapping to parameter:
eg: Param.CurrDate= TempPage.PxResults(1).PolicyDate
This value I'm getting through Connect SQL which is storing in specified TempPage in clipboard,however policydate field is specified as varchar(20) in sql server from where this value is getting fetched using connect sql.
Error:
value 18010 is not a valid Date or DateTime string. Details: Invalid value for theDate passed to RUF-addToDateYM.addToDate(String, String, String, String, String)
Thanks,
SorenTara
Northbridge
CA
Hi Sorentara,
Seems like there's no available function in PRPC to convert a date string to GMT. So you might need to create a custom function which would do the GMT conversion.
Below code could be taken as a reference. But this one's just sample for a format mm/dd/yyyy or m/dd/yyyy
//Format accepted : mm/dd/yyyy or m/dd/yyyy
String GMT = **dateinput**;
String [] array = GMT.split("/");
//adding a zero to handle single digit date or month
if(array[0].length() == 1 )
array[0]= "0" +array[0];
if(array[1].length() == 1 )
array[1]= "0" +array[1];
GMT = array[2] + array[0] + array[1] + "T000000.000 GMT";
return GMT;
Hi Sorentara,
Seems like there's no available function in PRPC to convert a date string to GMT. So you might need to create a custom function which would do the GMT conversion.
Below code could be taken as a reference. But this one's just sample for a format mm/dd/yyyy or m/dd/yyyy
//Format accepted : mm/dd/yyyy or m/dd/yyyy
String GMT = **dateinput**;
String [] array = GMT.split("/");
//adding a zero to handle single digit date or month
if(array[0].length() == 1 )
array[0]= "0" +array[0];
if(array[1].length() == 1 )
array[1]= "0" +array[1];
GMT = array[2] + array[0] + array[1] + "T000000.000 GMT";
return GMT;
Also the time difference btw the timezones should be handled while conversion.
-Shruthi