>>Given: cTimeStamp="200512081545"
>>Then TRANSFORM(cTimeStamp,"@R 9999/99/99 99:99") returns "2005/12/08 15:45" as expected.
>>
>>Let's say I want it to return "2005/12/08 at 15:45"
>>This causes a problem.
>>TRANSFORM(cTimeStamp,"@R 9999/99/99 at 99:99") uses the "a" in "at" as part of the format mask.
>>
>>Is there a way to specify an "escape" character so you can actually interpose an "a" or a "#" or a "!" as a fixed part of the output?
>>
>>THanks very much.
>
>Mark,
>Formerly I needed the same thing and couldn't find a direct solution. Instead I placed placeholder and replaced it. ie:
>
>? Strtran(TRANSFORM(cTimeStamp,"@R 9999/99/99 --- 99:99"),'---','at')
>
>Cetin
Thanks... that's what I'm going to do too.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only