Date Format

[upaliwije]

Hi Friends

I have a field in my data tale namely 'TRAN_DATE' and it is shown below. I have formatted my date field with following script in my data load

DATE(FLOOR(Timestamp#(TRAN_DATE,'MM-DD-YYYY hh:mm:')),'DD-MM-YY') AS TRAN_DATE1

But the result is blank in my output report. Kindly help me

[tresesco · Accepted solution]

Try like:

DATE(FLOOR(Timestamp#(TRAN_DATE,'MM-DD-YYYY hh:mm:ss TT')),'DD-MM-YY') AS TRAN_DATE1