Date format

[Anonymous]

Hi,

I am having date format llike 30-11-2016.txt .how can i remove .txt from the date.

[tresB · Accepted solution]

Try like:

Purgechar(DateField, '.txt')

Or,

SubField(DateField,'.' ,1)

[Anil_Babu_Samineni]

You can use many ways

1) SubField('30-11-2016.txt', '.', 1)

2) Replace('30-11-2016.txt', '.txt', '')

3) Left('30-11-2016.txt', 10)

4) PurgeChar(''30-11-2016.txt', '.txt')

[Anonymous]

Thanks for your Immediate rly.