Question

3
Replies
4643
Views
 Rajaiah Gone (RajaGone)
GDIT

GDIT
US
RajaGone Member since 2016 1 post
GDIT
Posted: November 29, 2016
Last activity: May 18, 2017
Posted: 29 Nov 2016 3:40 EST
Last activity: 18 May 2017 1:22 EDT
Closed

How to convert "20160922T040000.000 GMT" to 09/22/2016?

Hello All,

How to convert "20160922T040000.000 GMT" to 09/22/2016?

Thanks in Advance!

***Updated by moderator: Lochan to create new post from this comment; add topic categories***

User Experience
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 4 years ago
Posted: 29 Nov 2016 3:51 EST
Tuhin Guha (HectorYNWA)
Infosys

Infosys
IN

Please try @DateTime.FormatDateTime(.pxCreateDateTime,"MM/dd/YYYY",GMT,""). Replace pxCreateDateTime with the name of the date time property that you have. Please take care of timezone and locale parameters.
Posted: 4 years ago
Posted: 6 Dec 2016 10:15 EST
Rajaiah Gone (RajaGone)
GDIT

GDIT
US

How to convert "20160922T040000.000 GMT" to 09/22/2016? 


Actually I am trying write function using input type  'DateTime' and return type 'Date' SOURCE is "trunc({1})" I am getting one day less like "09/21/2016" but I need 09/22/2016.