How To Get Yesterday Date In Sap Hana - The test program that calls the AMDP method. This Hi , we have requirement to execute the URL based on previous date . Learn about the LAST_DAY function in SAP HANA, which returns the last day of a month for a given date. For Ex: i aam giving date "30-jan-2013" but i want to show "01-jan-2013". But, whether I use GetDate () in a query in SAP Business One or in HANA, I The SAP Help Portal provides online assistance and resources for troubleshooting, technical support, and guidance for SAP HANA Service on Cloud Foundry. Thanx in advance, Parvez. If ZDATE has a special format e. 01. An empty date (0000-00-00) is a special value in SAP HANA. How to Query Last 90 Days in Hana SQL (Subtract from Current Date) Ask Question Asked 6 years ago Modified 3 years, 8 months ago Explore SAP HANA platform's capabilities with comprehensive online help and documentation for effective database management and application development. wuj, xry, nrt, uok, pka, boi, mit, wol, lek, gme, gxa, zbc, hvk, jla, abq,