Date Time Conversion

timewaste

Hello Peers,

Can anyone help me convert this Oracle SQL statement into a formula tool expression? Appreciate your time.

SELECT to_char(replace(replace(to_char(SYSDATE ,'MMDDYY HH24:MI:SS'),':',''),' ','')) vdate FROM DUAL;

My formula though is this:

ReplaceChar(ReplaceChar(ReplaceChar(ToString(DateTimeNow(), 0), '-', ''),' ', ''),':','')

Thanks.

Treyson

Okay, I am still having a bit of a hard time following exactly what the ask is, however, I would suggest that you check out the custom parsing option on datetime parse.

You can either send a datetime in as the format you are asking for (dd-Mon-yy) or take that format and convert it to a datetime.

I have attached an example workbook for you.

datetimeParse Example.yxmd