I'm trying to create a new field in the load script which indicate the max date of 4 other fields (DateFacture, DateRapport, DateRDV and DatePriseRDV).
It should be pretty straightforward, but, for some reason, I'm not able to get it right.
Could you help me ?
May be used RangeMax() function
LOAD Date(RangeMax(DateFacture, DateRapport, DateRDV, DatePriseRDV)) as MaxDate
It seems to work but I've juste realised that :
- DateRDV and DatePriseRDV are in date format "DD/MM/YYYY"
- DateFacture are DateRapport,are in timestamp format "DD/MM/YYYY hh:mm"
so it only calculates max value between DateRDV and DatePriseRDV
I've found the solution in the end :
I've changed the format of my timestamp value using :
Thank you Sunny !
You can go for what Sunny has suggested.
Retrieving data ...