Is there any way to edit the format of a datetime field to produce an output similar to my formula below:
totext(datepart("ww",{SHIPLINES.SHPMT_DATE})) + "/" + totext(datepart("yyyy", {SHIPLINES.SHPMT_DATE}))
I'm unable to use this field in selection criteria or as properly sorted date field in charts because it is a string.
I feel there must be a way to achieve this by applying a custom stlye to the datetime field...... is there?
Ben
totext(datepart("ww",{SHIPLINES.SHPMT_DATE})) + "/" + totext(datepart("yyyy", {SHIPLINES.SHPMT_DATE}))
I'm unable to use this field in selection criteria or as properly sorted date field in charts because it is a string.
I feel there must be a way to achieve this by applying a custom stlye to the datetime field...... is there?
Ben