Change Date Format Based On Database Value 关注
Is the any way to change the format of a date based on a database field.
- Database is queried for the product number.
- The operator picks a manufacturing date with a date picker control.
- The picked date is offset by number of months specified in the database.
- I need the date after the offset to display as "MM/yy" for USA destination and "yy/MM" for Korea destination.
I'm using version 10.1 sp1 professional edition.
Current solutions is to use multiple data sources for the same data one for each different format. The using scripts data is only populated into 1 field. I feel like there should be a simpler way.