Date conversion

[marco_puccetti]

Hello, i need to get the Italian Format of the date, like this should work but it doesn't work:

date#(left(publishedAt, 10), 'DD-MM-YYYY')

publishedAt is a date in timestamp form us.

Marco

[fvelascog72]

Hi,

Which is the format of your timestamp field?

Regards

[PrashantSangle]

Hi,

Try below

date(date#(publishedAt,'DD-MM-YYYY hh:mm:ss tt'),'DD-MM-YYYY')

or

date(publishedAt,'DD-MM-YYYY')

If it not work post sample date

regards

[rubenmarin]

Hi Marco, Date#() is used to tell QV wich is the format of the date readed, that is telling:

Transform to a Date this string wich is a date in the format 'DD-MM-YYYY'.

If you want to add another format you can enclose that expression into a Date() function:

Date(date#(left(publishedAt, 10), 'DD-MM-YYYY'), 'DD/MM/YYYY')

[#5]

Hi Macro,

Date#():it just evaluate the expression

Date(): formats the expression as a date

Try like this

date(date#(left(publishedAt, 10), 'DD-MM-YYYY'))

If not post format of the 'publishedAt' field..

[marco_puccetti]

If i use this form the data is not shown!!

Marco

[#7]

Can you please post the format of 'publishedAt' field?

[Colin-Albert]

Date#() sets the input format of a date

Date() sets the output format of a date

Have a look at this post  Get the Dates Right

[buzzy996]

u have to use either of of these functions with corresponding format whichever u like to see on front end.

Date#()

Date()

[marco_puccetti]

YYYY-mm-dd hh:mm:ss

Marco