Date issue

[Anonymous]

Hi,

I have an issue with date.

I am trying to convert date value YYYYMMDD to DD/MM/YYYY. But it is not giving any result with the below expressions.

=Date(Floor(TimeStamp#(site_visit_start_datetime_key, 'DD/MM/YYYY hh:mm:ss')))

=Date(Floor(TimeStamp#(site_visit_start_datetime_key, 'DD/MM/YYYY')))

Any suggestions on this

Regards,

Kumar

[sunny_talwar]

May be this:

Date(Floor(TimeStamp#(site_visit_start_datetime_key, 'YYYYMMDD hh:mm:ss')), 'DD/MM/YYYY')

[Anonymous]

Thanks sunny for your reply. But no use

[arulsettu]

post some sample file

[sunny_talwar]

Can you share the current format of site_visit_start_datetime_key field?

[Anonymous]

Pls find the screen shot.

[sunny_talwar]

This looks like a datefield and not timestamp. May be this:

Date(Date#(site_visit_start_datetime_key, 'YYYYMMDD'), 'DD/MM/YYYY')

[Kushal_Chawda]

try this

Date(Date#(site_visit_start_datetime_key, 'YYYYMMDD'), 'DD/MM/YYYY')

[Anonymous]

Thanks Sunny. It is working fine.

Being new to this Qlikview. Can you tell me, Is there any way to find out whether date field is date or not.

[bohravanraj]

=Date(Date#(site_visit_start_datetime_key,'YYYYDDMM'),'DD/MM/YYYY')