Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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 ?
Thanks
Aurore
May be used RangeMax() function
LOAD Date(RangeMax(DateFacture, DateRapport, DateRDV, DatePriseRDV)) as MaxDate
May be used RangeMax() function
LOAD Date(RangeMax(DateFacture, DateRapport, DateRDV, DatePriseRDV)) as MaxDate
Thanks,
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
You can go for what Sunny has suggested.
I've found the solution in the end :
I've changed the format of my timestamp value using :
date(Timestamp#([DateFacture],'DD/MM/YYYY hh:mm'))
Thank you Sunny !
No problem