HOw to show Time along with date??

[nikhilgarg]

Hey ,

I am Comparing two time variables with each other.

But  the problem is these 2 variables are incomparable with each other becoz one date is in 'YYYY-DD-MM' and other in 'DD-MM-YYYY'

When i am trying to convert one date to 'YYYY-DD-MM' , my time is erased so again not comparable.

How to show time , please tell.

--------------------------------------------------------------

Directory;

LET vModifiedTime = Date(floor(FileTime('C:\Users\nikhil.garg\Desktop\Disaster_Data\Copy of Disaster.xlsx')), 'YYYY-MM-DD');

LOAD *

FROM

[Disaster_Data\Copy of Disaster.xlsx]

(ooxml, embedded labels, table is Disaster) where $(vModifiedTime) >= $(LastExecTime);

Please help.

Thanks

[maxgro]

to change format from DD-MM-YYYY to YYYY-MM-DD you can use

=Date(Date#('25-02-2012', 'DD-MM-YYYY'), 'YYYY-MM-DD')

replace '25-02-2012' with your field or var

[nikhilgarg]

But i ahve to show time also , along with date. How can i do it ?

[#4]

Hi Nikhil,

Try this format in your expression - "YYYY-DD-MM h:mm:ss[.fff] TT"

This format will show you time as well with AM / PM suffix.

If you want to remove AM / PM from your timestamp, remove TT from the format.

Regards,

Sarang M. Mehta

[PrashantSangle]

Hi,

When you use Floor() It will give rounded date .It will remove your time field

So if you need Time also then dont use Floor()

Regards

[PrashantSangle]

Hi,

and also use Timestamp(), Instead of Date()

Regards,

[maxgro]

change the format

=Date(Date#('25-02-2012 14:35:03', 'DD-MM-YYYY hh:mm:ss'), 'YYYY-MM-DD hh:mm:ss')

you can try in a textbox

[MarcoWedel]

how do you calculate LastExecTime?

[nikhilgarg]

Hey,

I have used $(LastExecTime) dat automatcally gves last executn time. But

format of lastexectime and modified time is dofferent. Thats the issue

[#10]

Hi Marco,

Use function QvdCreateTime.

EG:- QvdCreateTime('C:\MyDir\MyFile.qvd')