is there a way i can change the gloria food pickup minutes to Time like for an example if the order is put through at 04:00pm and Pickup minutes is 60 , i want it to show the actual date and time 30/05/2025 05:00pm
Functions:
ADS(date_time, seconds)
– Add seconds to date_time
FD(date_time, str_format)
– format date_time to string format
[=FD(ADS('{TICKET DATE}',900),'hh:mm')]
^ If ticket date is 05-31-2025 00:00, it will add 900 seconds (15 mins), and format date will convert it to string of hh:mm which results in 00:15
If you dont need to format your date time, dont use FD() – it will use your windows regional settings for default format
2 Likes
thanks that really did the trick