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,

Try this:

Date(Date#(publishedAt,'YYYY-mm-dd hh:mm:ss'),'DD-MM-YYYY')

[rubenmarin · Accepted solution]

Probably needs uppercase for the month and day parts:

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

[buzzy996]

i think u can try this,

timestamp#(A,'YYYY-MM-DD hh_mm') where A=1997 08-

06 09_00 returns

[MarcoWedel]

Date(Floor(Timestamp#(publishedAt,'YYYY-MM-DD hh:mm:ss')),'DD-MM-YYYY')

[#6]

date(date#(publishedAt,'DD-MM-YYYY') )    try this

[marco_puccetti]

I have tried in many modes, but it still return date in yyyy-mm-dd.

This is the script:

YOUTUBE_Media:

LOAD

  kind as VideoSearch_kind,

  videoId as Video_id,

  videoLink as VideoSearch_videoLink,

  publishedAt as VideoSearch_publishedAt,

  timestamp#(left(publishedAt, 10) & ' ' & mid(publishedAt, 12, 8), 'YYYY-MM-DD hh:mm:ss') as VideoSearch_publishedAt_qlik_timestamp,

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

  channelId as VideoSearch_channelId,

  channelLink as VideoSearch_channelLink,

  channelTitle as VideoSearch_channelTitle,

  title as VideoSearch_title,

  description as VideoSearch_description,

  thumbnailDefaultUrl as VideoSearch_thumbnailDefaultUrl,

  liveBroadcastContent as VideoSearch_liveBroadcastContent

FROM

  [$(vQVSourceBaseUrl)/QVSource/YouTubeConnectorV3/?table=VideoSearch&appID=$(vQVSourceAppId)&query=$(site)](qvx);

Thanks

Marco

[buzzy996]

can u share publishedA source date as a sample?

[marco_puccetti]

Now it's ok!!

Thanks

Marco