Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have date field in this Format: 07-08 8-2013 12:44:11
I need date field in this Format: 07-08-2013 12:44:11
Only Month is in different Format.
I am getting desired result by using this:
SubField(SystemClosedDateTime,'-',1)&'-'&Left(SubField(SystemClosedDateTime,'-',2),2)&'-'&Left(SubField(SystemClosedDateTime,'-',3),4)
Is there any other way which will only change the month Format (08 😎 and rest Date and Year work as it is.
Regards
Aviral Nag
Hi,
Just write ,
Timestamp(SystemClosedDateTime,'DD-MM-YYYY hh:mm:ss')
Regards,
Try like:
Load
Date(Floor(Timestamp#(YourDate, 'DD-MM M-YYYY hh:mm:ss'))) as Date
Sir
I need this Format: 07-08-2013 12:44:11
Hi,
Try this one:
=Date(Date#(SystemClosedDateTime,'DD-MM D-YYYY hh:mm:ss'),'DD-MM-YYYY hh:mm:ss')
HTH
Sushil
Then try without floor(), like:
Load
Timestamp(Timestamp#(YourDate, 'DD-MM M-YYYY hh:mm:ss')) as Date
did you try
on the load
date(floor (SystemClosedDateTime)) as date,
Hi,
Try this,
Timestamp(Timestamp#(DateFieldName, 'DD-MM M-YYYY hh:mm:ss'),'DD-MM-YYYY hh:mm:ss') as newDate
Regards
Try this in text object
Timestamp(Timestamp#('07-08 8-2013 12:44:11', 'DD-MM f-YYYY hh:mm:ss'))
you get this output 07-08-2013 12:44:11
hope it helps
Thanks Everyone for the Result.
I've applied everyone's logic but it's not working perfectly.
Kindly, see the Attachment.
Hi,
Just write ,
Timestamp(SystemClosedDateTime,'DD-MM-YYYY hh:mm:ss')
Regards,