I'm working on a file based on a BO extraction where i got 2 fields as date.
Unfortunately when the files are loaded i got values in this way 40817,12354 which is the xls date format, how could I transform them into DD/MM/YYYY?
Thanks in advance
In the load script, if the field name is MyDate:
Date(MyDate,'DD/MM/YYYY') as MyDate
Thanks, the problem is that even if correctly converted if I use it in as list i got separate values for the same date.
It seems it is still reading the time part...
Date(floor(MyDate),'DD/MM/YYYY') as MyDate
Thanks a lot...i tried the same with the month and the year but is still duplicating
Tell me how you have the month and year defined in your script.
SET TimestampFormat='DD/MM/YYYY h.mm.ss[.fff]';
This is just how the formatting is set.
When you say the months and years are duplicating, I assume you are talking about fields in a list box or table.
How are you loading those fields in your script?
If you could attach a sample qvw demonstrating the problem, that would also be helpful.
DATE("Your field",'DD/MM'YYYY') AS "Field Name"
and if you are getting duplicate value...than you can use the dual()
Hi, as attachment the report i'm working on...
use dual in this as:
dual((Month(Date) &'-'&Year(Date)),num(MakeDate(year(Date),month(Date)))) as Monthyear
hope this will help you.
You can use the DATE function in the script or front end to correct the field format. For Example:
DATE("Your Date Field",'DD/MM'YYYY') AS "Date Field"
Front end Expression:
DATE("Your Date Field",'DD/MM'YYYY')
I solve this issue....now I'm working on the traffic light indcator....i would set the indicator on this expression:
count (num att) if codice esito= ok / count (num att)
Retrieving data ...