topic How to compare file time with today's date in QlikView

How to compare file time with today's date

posywang — Wed, 21 Feb 2018 15:45:13 GMT

Hi, can anyone show me how to compare file time of a source file with today's date? I am trying to write script to stop the app running if file time is earlier than today's date. Thank you.

Re: How to compare file time with today's date

YoussefBelloum — Wed, 21 Feb 2018 15:56:49 GMT

Hi,

for the file time you have this:

FileTime() => it return a timestamp, so yo should do this: Date(Filetime())

IT IS A SCRIPT FUNCTION

and for today date, you have this:

Today()

so you can compare like this:

if(filetime(file.extention) <..>..<=..>=.. today(), ..., ...) as ...

Re: How to compare file time with today's date

bnichol — Wed, 21 Feb 2018 16:09:15 GMT

exit script when filetime( 'your file location' ) < today()

Re: How to compare file time with today's date

vishsaggi — Wed, 21 Feb 2018 16:42:50 GMT

Try this and change your script accordingly.

Change the file paths and filenames accordingly.

SET vFilePath = 'P:\SetAnalysis_Udemy\';

LET vFileTime = Date(FileTime('$(vFilePath)Bubble.qvw'));

IF $(vFileTime) >= Date(Today()) Then

Load * INLINE [

Name, ID

A, 2

B, 3

C, 4

];

ELSE

Exit SCRIPT;

ENDIF;