Date Function

[#1]

hi all,

      I am new to QV,I stucked with these date function.9/22/2015 12:00:00 AM ,i want to show these date like 9/22/2015 excluding time stamp.I have tried these but it is not working =date(date#('9/22/2015 12:00:00 AM','M/DD/YYYY h:mm tt'),'MM/DD/YYYY').

Can any one help on these

Regards,

Sruthi

[maxgro]

use floor function for date part

=floor(date#('9/22/2015 12:00:00 AM','M/DD/YYYY hh:mm:ss tt'))

and frac for time

[Gabriel]

Hope this help

=Date(Floor('9/22/2015 12:00:00 AM'),'MM/DD/YYYY')

[Anonymous]

Try  this.

=Date( Timestamp#('9/22/2015 12:00:00 AM','MM/DD/YYYY hh:mm:ss tt'),'MM/DD/YYYY')

[#5]

Hii

Try this expressions

dual( Date('YYYY-MM-DD') & time('hh:mm:ss').

or

floor(TimeStamp) will give data.

TimeStamp - Floor(TimeStamp) will give Time

Both will have to be formatted.

or

=timestamp(Your Field,'h:mm:ss TT')

[senpradip007]

Use this

=date(date#('9/22/2015 12:00:00 AM','M/DD/YYYY h:mm:ss TT'),'MM/DD/YYYY')

[Anonymous]

Sruthi,

Just go through HIC blog .. you will be clear on date functions .

The Date Function

Thanks

BKC