date format

[master_student]

Hello Guys,

I hope all is well.

I have a date field with that format

valid_from

12/08/2015 00:00

I did the expression bellow in the script to extract only the date  DD/MM/YYYY

Date(Date#(valid_from, 'DD/MM/YYYY'), 'DD/MM/YYYY') AS detection_date  but it returns nothing

do you have any idea please?

Thanks

[MK_QSL]

Date(Floor(TimeStamp#(valid_from, DD/MM/YYYY hh:mm'))) as detection_date

or

Date(Floor(TimeStamp#(valid_from, DD/MM/YYYY hh:mm')),'DD/MM/YYYY') as detection_date

[#3]

Hey Wiem,

In your original string, the date and time is formatted like 'DD/MM/YYYY hh:mm'

You need to make sure that in the Date#(valid_from, 'DD/MM/YYYY') function the date itself is formatted as how it is

in the original string so:

Date(Date#(valid_from, 'DD/MM/YYYY hh:mm'), 'DD/MM/YYYY') AS detection_date

Good luck!

Ivo

[master_student]

Thanks but it didn't work.

[vishsaggi]

Can you share your script or a sample app to look into?

[qlikview979]

Hi,

I hope this is helpful to you

   Floor(valid_from)   as valid_from

Regards,

Mahesh