andie_popkov
26th July 2005, 03:54
Yes, I need this simple function, but I can't find its syntax. Need to get a string like this:
S = "Date from " & str$(date1) & " to " & str$(date).
mr_suleyman
26th July 2005, 08:13
Hi there ,
I meant that you wanne get string from date and concat operation as you write.
Firstly you can use DATE.TO.INPUTSTR$() function
you can look at its usage from tools programming.
For example
string mystr(8)
mystr = date.to.inputstr$( date1,"%D002,3",8)
next ,
your string = mystr & "WORD" & " XXXXX " ...... l
Good luck!
evesely
26th July 2005, 15:27
If you want a bit more flexibility with the dates, you might try using sprintf$. There are many different options. Here is just one possibility using mm/dd/yyyy format on both dates:
S = sprintf$("Date from %D(%02m/%02d/%04Y) to %D(%02m/%02d/%04Y)", date1, date2)