Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
my computer and qlikview docs date/time sequence is off.
I did an expression monthend(date_field), date field='6/30/13, but the returned value is '5/31/2013'.
Once I did weekday(date_field), and returned Tues. should be sun
how do I fix this? I know I can change the sequence in script set statement, but since I share multiple machines with teammates, other machines are right, but this one is off.
Thanks
I can only imagine an issue with date formats or date manipulation, but really hard to tell with the information given.
Could you upload a small sample app that demonstrate this issue?
I can't, because if u download the file to your drive since you have correct setting in your computer, then monthstart(10/04/2013) going to give you 10/1/2013.
my bad computer give me 9/1/2013
I opened the same document on a different computer, then it's 10/1/13
I wasn't doing anything fancy, just a text box with a simple function
Well, maybe a close look to your app's settings and script may help to understand the problem.
For example, what standard date formats are used in your script?
Could you post your Date/Time settings?
SET ThousandSep='.';
SET DecimalSep=',';
SET MoneyThousandSep='.';
SET MoneyDecimalSep=',';
SET MoneyFormat='R$ #.##0,00;-R$ #.##0,00';
SET TimeFormat='hh:mm:ss';
SET DateFormat='DD/MM/YYYY';
SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';
SET MonthNames='jan;fev;mar;abr;mai;jun;jul;ago;set;out;nov;dez';
SET DayNames='seg;ter;qua;qui;sex;sáb;dom';
SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='$#,##0.00;($#,##0.00)';
SET TimeFormat='h:mm:ss TT';
SET DateFormat='M/D/YYYY';
SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';
I need to show you a demo, sorry got so busy. I just avoided using that machine for tool reloading. but I would like to figure this out