Date Format Issue

[#1]

Hey,

I have date in the following format including time stamp.

29/09/2013 09:15

When I load this date field in qvw file it is represented in the following format

41487.4638888889

I want to separate time stamp and date in order to use only date as dimension.

any ideas??

[#2]

try this

date(date#(fieldname,'DD/MM/YYYY hh:mm'),'DD/MM/YYYY hh:mm')

[#3]

hi

try this

in script-

Date(Date#(datefieldname,'DD/MM/YYYY hh:mm'),'DD/MM/YYYY hh:mm') as datefield

example--

in text box

=Date(Date#('29/09/2013 09:15','DD/MM/YYYY hh:mm'),'DD/MM/YYYY hh:mm')

[manojkulkarni]

use Date() function, below is sample

Date(datefield,'DD-MM-YYYY') for date

Date(datefield,'hh:mm') for timestamp

[Sokkorn]

Hi Hannan,

Floor(DateField) As Dates -> return 41487

See this and this for details.

Regards,

Sokkorn

[#6]

Vishwaranjan,

I want to remove the time stamp from the date preserving the actual date ..  I dont want timestamp in my date.

[#7]

I have date like this in excel file

29/09/2013 09:15

and when excel file is Loaded in the qvw it shows

41487.4638888889

I want to remove time stamp from my date.

I have this '29/09/2013 09:15'

I want this '29/09/2013' in my qvw.

[er_mohit]

Try this

date(date#(fieldname,'DD/MM/YYYY hh:mm'),'DD/MM/YYYY') as Date,

time(time#(fieldname,'DD/MM/YYYY hh:mm'),'hh:mm') as Time

[#9]

try this

Date(Date#(datefieldname,'DD/MM/YYYY hh:mm'),'DD/MM/YYYY') as datefield

[Sokkorn]

Hi Hannan,

That very clear. This one should do your job

Date(Floor(DateField)) As Dates

Regards,

Sokkorn