Timestamp to Date format, but not working.

[#1]

Hi,

I have a super simple problem, but a problem nonetheless.

I have a field called newDate which I had converted from Timestamp format into Date format.

floor(oldDate) as newDate

But, tadaaaa, it gave me numbers instead: 41408.

I need to display the date in my textbox. I used the following expression but it doesnt work.

=date(date#(newDate, 'M/DD/YYYY'), 'DD/M/YYYY')

initially the format was in timestamp, like this: 5/14/2013 12:00:00 AM

any idea how to convert those numbers back to date format?

[narender123]

Hi,

I think you need to do it as

=date(date#(newDate, 'MM/DD/YYYY'), 'DD/MM/YYYY')

OR IN SCRIPT LEVEL  MAKE FILED AS

Date(yourdatefiled,'DD/MM/YYYY')

Thanks

[Gysbert_Wassenaar · Accepted solution]

You can create the field like this in the script to give it a date format: date(floor(oldDate),'DD/MM/YYYY') as newDate

Or if you want to format it in an expression: date(newDate,'DD/MM/YYYY')

Or if you want to format it in a listbox, click on the Number tab, choose Date and enter DD/MM/YYYY as format string

[#4]

thank you all, it works perfectly!

[#5]

That was so helpfull!

Thanks!