topic Data Format in QlikView

Data Format

mario-sarkis — Wed, 25 Nov 2020 16:16:04 GMT

Hello!

hope that you can help with this,

I need to transform this date format for example:

'01/02/2018 44:00:33' need to transform it to '01/02/2018' noting that the format date is a number.

Thank you in advance

ruanhaese — Mon, 25 Jun 2018 06:59:42 GMT

Depends how the date comes in (is it text or already a date number)

If its text you need to include the date# otherwise you can exclude it and just format it

Date( FieldDate, 'dd/MM/YYYY') Or

Date( Date#( FieldDate, 'dd/MM/YYYY HH:mm:ss'), 'dd/MM/YYYY')

tresB — Mon, 25 Jun 2018 07:00:29 GMT

If your date is a number, try like:

Date(Floor(DateField), 'DD/MM/YYYY') as NewDate

vipin_mishra479 — Mon, 25 Jun 2018 07:00:33 GMT

Try This

Date(Date#(Date field ,'DD/MM/YYYY hh:mm:ss'),'DD/MM/YYYY')

Hope this will help !!