Try to add in your script this :
timestamp([YourDateField],'h:mm:ss TT')>='1:00:00 PM',
Date(Floor(Date([YourDateField],'DD MMMM YYYY hh:mm')+1),'DD/MM/YYYY'),
) as NewDate,
This one may work also :
timestamp([YourDateField],'h:mm:ss TT'))>='1:00:00 PM',
Date([YourDateField],'DD/MMM/YYYY')) as NewDate,
Hi Bruno - thanks for taking the time to reply to me . I really appreciate it.
Your script is obviously good, but in the editor I am using (as part of data manager, not data load editor), Qlik Sense cannot seem to accept the use of certain symbols. Please see picture attached. It is the case for > or =
Any thoughts? Maybe I can only do this effectively in Data load editor - I will need to get familiar with this if this is the case.
Thanks for your support
The intention of the Data Manager is to keep things quick and simple. While more heavy lifting data transformation are intended to be done in the Script Editor. That said I understand your frustration of having something work in one place and not the other place. I will raise this with our Products team to investigate.