I usually use the below function to create a dated file name.

format$("YYYYMMDDhhmmss", datetime$)

Below will format more like the native datetime$ without the colons.

format$("YYYY[-]MM[-]DD[T]hhmmss[Z]", datetime$)

Do you know how to change the datetime$ so it is not in England time

Datetime$ is in UTC. Date$ contains local time based on the server time. Below is the original formula with the date$ substitution. I also dropped the Zulu literal suffix.

format$("YYYY[-]MM[-]DD[T]hhmmss", date$)

Just what I was looking for! Thanks. 

Just what I was looking for! Thanks. 

This is old but maybe my comment is useful for someone in the community. 

I try this what Rod comment here, but when i used that formula the result was the actual time even if i replace the 'date$' for the date field on Sage. So, i tried something more 'manual' but it works for me.

This is an example that i used for the BPC object: 

format$("YYYY[-]MM[-]DD[T ]", [F:BPC]UPDDATTIM)+num$(val(format$("hh",[F:BPC]UPDDATTIM))-3)+':'+format$("mm",[F:BPC]UPDDATTIM)+':'+format$("ss",[F:BPC]UPDDATTIM)

I use this formula in the GESAOP function, for the 'Properties' of the object.

Hi ChrisCC, happy to see that the community helped you figure out a solution!

If you have a minute, tell us about your great experience on Sage City, take this short survey