is there a way to formt the date so it show 190531 so that would mean May 31, 2019? I need it formatted this way since the import template is storing the date in this format.
Thanks,
Chris
Hi Chris,
you can change your regional preferences: All --> Administration-->Administration -->Settings
Choose your region and change it in the way you need it. That will change it in all the screens.
If you just want to change an import template, you can change the date format template on Setup --> Usage -->Import / Export templates
Regards
I need the date to come out like this in 4GL...
I am doing an auto import via 4GL logic
I'm not sure I properly understand what you are looking for. If you are looking for 4GL code to output a YYMMDD date string, you can use something like the below example. I'm using the current date function but you can replace the date$ with the source field.
format$("YYMMDD", date$)
*Community Hub is the new name for Sage City