Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mario-sarkis
Creator II
Creator II

Data Format

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

3 Replies
ruanhaese
Partner - Creator II
Partner - Creator II

Hi

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')

tresesco
MVP
MVP

If your date is a number, try like:

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

vipin_mishra479
Creator II
Creator II

Try This

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

Hope this will help !!