This content has been marked as final. Show 3 replies
I got 2 date fields:
- "Dt End"
- "Dt Start"
Which are in the xls format:
Dt End 40820,50326
Dt Start 40820,01286
I need to create a new filed which reports the difference between this dates in terms of numbers of days.
I used this: Interval ("Dt End"-"Dt Start",'DD') as "Giorni"
But is not working properly..it gave me results formatted in days but is seems is having decimals (not expressed) so i got lots 00,01,02,03,04 but i need them as unique values