Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to convert time stamp into date, but i am not able to convert it.
I tried it =
date([Time Full Date],'DD/MM/YYYY') and the expression is ok,but in list box it is displaying nothing. Not only in listbox in all reports the same problem.
Pls help me on this.
Regards,
kumar
what is the current date format?
maybe you need to convert it to a dateformat using date#
e.g. date(date#([Time Full Date],'YYYY-MM-DD'),'DD/MM/YYYY') if your dateformat now is YYYY-MM-DD
Check your date format and adjust it in the expression above in the date# part
I guess you need to remove timestamp and restore only date from the field.You can use rounding function to remove timestamp,
=Date(Floor(Now()),'DD/MM/YYYY')
Are you sure Time Full Date is recognized as a valid timestamp when you have loaded?
Hi,
My date format is YYYY-MM-DD.
I tried as said, but it is not giving any results. I am able to convert now() into date format.
Yes.
Regards,
Kumar
Can you upload the file? so we can check it?
this is how the result giving without applying date([Time Full Date],'DD/MM/YYYY')
i tried with just [Time Full Date] and it is giving below result.
Use Subfield([Time Full Date],' ',1) or Left([Time Full Date], 10)
pfa